Forum

Have you tried this? Click on a column header for the response type. Hover the mouse over the edge of the cell until you see the 'four arrowhead' (PC)...

Excel for the Mac has nearly all the features that Excel offers to Windows users, The user interface, however, is quite different in many places as yo...

Move the 'else if' where you check for 51626 above the one where you have 'else if..... begins with 5'. Then it will work.

One way would be to merge the accreditations with the course list (left outer join) as demonstrated in the attached file.

Perhaps Phil's blog post on Grouped running Totals in PQ is what you need.

Perhaps the example in the attached file helps you on your way. The formula itself is as simple as: =B2-A2 That will result in a numer repres...

Hi, if you intended to upload a file, please try again. Don't forget the 'Start upload' button and wait until it's ready before you submit your reply.

That would be: DateTime.LocalNow() And then set the column data type to Date. That does what TODAY() does in Excel.

Not sure is this is what you asked for and there could be better ways to do it. DAX isn't my strongest point. Have a look at the attached workbook ...

Try again to upload your file. Don't forget to press 'Start Upload' and wait until it's finished before submitting your reply.

I did not select the 'Multiple items' box for reason. Selected just one of the tables. Doesn't matter which one. Then delete the Navigation step that ...

A Left-anti join returns rows than exist only in the first table. Could it be that all rows from the first exist in the second? Then the result will b...

Please upload some files. It's still difficult to follow what you're doing based on text alone.

Give the sheets a neutral name like "Data" and add one column to each sheet/table, for instance "Category" where you enter Actual or Budget on each ro...

Difficult to diagnose without seeing the files. Can you upload two files with some mocked-up data but leaving the file structures exactly as they are ...