Before diving into the dashboard layout, you need to cover the basics. To make sure that time-intelligence functions work as intended, it’s best that you create a separate Calendar dimension table. Watch the video to learn how to easily create such a table and connect it to your data model.

Learn more about Calendar tables

DAX code for creating the table:

Calendar = ADDCOLUMNS ( CALENDARAUTO (), 
    "Year", YEAR([Date]),  
    "MonthNo", MONTH([Date]),  
    "Month", FORMAT([Date],"mmm"), 
    "Quarter", FORMAT([Date],"QQ"), 
    "YearMonth", FORMAT([Date],"YYYY-MM"),  
    "WeekdayNo", WEEKDAY([Date],2), //1-Sun..Sat, 2-Mon..Sat 
    "Weekday", FORMAT([Date],"ddd") )