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.

GENERATE and ROW DAX functions with calculated dates tables

GENERATE and ROW DAX functions with calculated dates tables - Power BI Tutorial

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

Start my 1-month free trial Buy for my team

GENERATE and ROW DAX functions with calculated dates tables

“

- [Instructor] The date table functions like CALENDAR and CALENDARAUTO in DAX are very helpful in building Power BI models, because they create contiguous date ranges. However, there are scenarios when we may not want to include every date between two dates in our dates table. For example, if we only do calculations for the first or last day of the month, quarter or year. Other table manipulation functions that we can use in DAX table formulas include ROW which creates a table with a single row with columns defined by the expressions we set within this formula. GENERATE creates a single table from calculating the Cartesian product of two separate tables. The Cartesian product is a set theory concept in mathematics that we can apply to data modeling. Let's say we have a table with two sets denoted as set A and set B. The Cartesian product of these two sets is the resulting set of ordered pairs that we get from…

Contents