Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › 11. Data Modelling

Why do you need a separate date table?

Why do you need a separate date table? Time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR need a date table with one row per day and no gaps. It also gives one place for Year, Month and Weekday.

Why do you need a separate date table? Time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR need a date table with one row per day and no gaps. It also gives one place for Year, Month and Weekday.
Download PNG

Lesson: 11.5 Date Table in Power BI with Example (April–March FY) · मराठी card