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") )