Last answered:

04 Oct 2022

Posted on:

02 Oct 2022

1

Resolved: Where did [Date] come from (5:58)?

Something I haven't come across until now? Can you please shed more light on where [Date] used in the ADDCOLUMN came from? A specific measure was not written for that and it got me wondering / curious. Many thanks in advance

1 answers ( 1 marked as helpful)
Instructor
Posted on:

04 Oct 2022

1

It is something that the Power BI engine does. Inside the ADDCOLUMN function you are specifying the CALENDAR function to create a range of dates between the min and max date then you add a comma and move onto building Year, Quarter, etc. But that first argument which is the CALENDAR function is where Power BI creates the Date column that you can refer in the rest of the functions.

Submit an answer