Jun 30 2020 01:40 PM
Hi,
I just created a Calendar table using the Power Pivot and therefore it is already in the data model as well. However, how can I have this in my Power Query so that I can use it in the Excel to Pivot or add Slicers?
Cheers,
Jun 30 2020 03:21 PM
Jul 01 2020 12:51 PM
These days best practice is to generate calendar initially by Power Query, not to generate it by Power Pivot. That's much more flexible solution. Just google for the pattern, it shall be lot of them.