From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

CALENDAR and CALENDARAUTO DAX functions

CALENDAR and CALENDARAUTO DAX functions - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

CALENDAR and CALENDARAUTO DAX functions

“

- [Narrator] Date tables are very helpful for Power BI modeling because having contiguous dates lets us do many different time intelligence calculations and ensures that certain built-in modeling functionalities work like forecasting. One function we can use to create dates tables is calendar auto. Notice that the only parameter is an optional one for a non-standard calendar year. This is because this function creates a table, but it implicitly uses the dates already in the model tables behind the scenes to create a new dates table. If we want to set the specifics of the date range more exactly, we can use the calendar dax function, which returns a dates table between the specified start date, and the specified end date, which can both be measures returning dates. Let's add another table to our Power BI model first using the default options for the calendar auto dax function without any input parameters.…

Contents