Power Query to move 24 values

let
    Source = Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content],
    ColD = List.Combine(List.Transform(List.FirstN(Source[D],

What's the best calendar strategy?

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...

Macro for filtering/copying/and pasting to new tabs

groan…
cross posted without links:
https://www.reddit.com/r/excel/comme...my_excel_file/
kamehameha1...

Applying Filter on Button Click

This can easily be done with the macro recorder.
Select the columns that contain your data.
Click on data, then filter.
Click on the...

Applying Filter on Button Click

Hello All,




I am trying to apply a filter from VBA code.




It's a table, named "AllProjectsOutstanding",...