Preparing calendar tables in Power BI
Hi All,
In this video, I have explained how to make calendar functions in Power BI using DAX. I have made five calendar tables using DAX functions and have explained the logic behind them in this video.
In order to come up with them, I have used DAX functions like Calendar, Calendarauto, Date, Min , Max, Format, Int, Month, Weekday, Year, Addcolumns, Filter & Var and Return statements of DAX.
The video starts with the usage of Calendar function and its parameters, then how to use calendarauto function along with its parameters, how to implement calendar function using calendarauto and how to get a full calendar table for time intelligence reporting using DAX.
If you find this video informative, then please like and share this video, let us know about your queries or doubts in the comment section and subscribe to our channel.
Follow us on facebook - facebook.com/mlforanalytics
Link to blog - mlforanalytics.com
Link to twitter - / jyotidixit1711
Contact me on linkedin - / dixit-jyoti