Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
What DAX function can be used to build a common date table in Power BI?
What DAX function can be used to build a common date table in Power BI?
- CALENDAR() (correct)
- MONTH()
- YEAR()
- CALENDARAUTO()
Why is it recommended to use a source date table if available?
Why is it recommended to use a source date table if available?
- It provides detailed sales data
- It includes complex formulas
- It is likely shared with other tools (correct)
- It automatically populates fiscal years
What does the WEEKNUM() DAX function do in building a date table?
What does the WEEKNUM() DAX function do in building a date table?
- Determines the fiscal year
- Calculates the week of the year (correct)
- Formats the date as 'DDDD'
- Returns the year from the date
