What's the best strategy for managing a dynamic calendar for DAX, as defined by Power Query?
We could keep it in the Data Model, in a worksheet...
groan…
cross posted without links:
https://www.reddit.com/r/excel/comme...my_excel_file/
kamehameha1...
This can easily be done with the macro recorder.
Select the columns that contain your data.
Click on data, then filter.
Click on the...
Hello All,
I am trying to apply a filter from VBA code.
It's a table, named "AllProjectsOutstanding",...
Power Query to move 24 values