All articles with 'calendar table' Tag
{ 7 Comments }
How to “auto” generate calendar tables with Power Query – The best method
Published on Aug 22, 2023 in Power BI, Power Query
![How to “auto” generate calendar tables with Power Query – The best method](https://chandoo.org/wp/wp-content/uploads/2023/08/CALENDAR-TABLE-POWERBI.jpg)
Calendar (or date) table is crucial for performing date intelligence calculations in Power BI.
Normally, you would find a reasonable calendar table in most data models. But occasionally I come across models where there is no calendar table.
So I present to you, the ultimate & best way to generate calendar table using Power Query.
Continue »