Power BI: calendar Table
When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions.
The easiest way to quickly create a calendar is to use the function CalendarAuto. It will automatically take the first and last dates from your data and produce a calendar. However, using the CalendarAuto function is a bad practice, as in some cases it may lead to mistakes in your data model.
That is why it is better to use the Calendar function: TableName = Calendar ([Start Date], [End Date]). If you don't know the start and end dates in your model, one solution is to use functions MIN and MAX inside the Calendar function.
To learn more about Power BI, go to: https://centida.com/index.php/blog/
Key words:
#PowerBI #DAX
#Calendar #Table
#HowTo #Data