🔥 3-day streak
Microsoft Power BI Data Analyst89 / 205
Question 89 of 205

You are building a Power BI model for a retail company. The Sales fact table contains an OrderDate column spanning January 2021 through the current date, but there is no dedicated date table in the model. You need to create a date dimension using a DAX calculated table that includes every day in the range with no gaps, so time intelligence functions work reliably. Which DAX expression should you use to define the calculated table?

Reviewed for accuracy · Report an issueNext question