Every Data Model in Power BI or Powerpivot needs a Date Table in order to use the time intelligence functions.
In this tutorial, we find the easiest way of creating a Data Table from scratch with Power Query.
We will use the List.Date() function in Power Query (M Language). It gives us incredible flexibility in quickly choosing the time interval of the Data Table.
===== CHAPTERS =====
0:10 - Why you need a Data Table
0:40 - List.Date Function
1:35 - Transform List to Table
1:55 - Add columns - Year, Month, Week
#powerbi #powerquery #datamodeling #dataanalytics