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

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.

Follow this topic

Bare Udusegbe

Last answered:

04 Oct 2022

Posted on:

02 Oct 2022

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

in Power BI / Task Three, Part 1

1 answers ( 1 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

04 Oct 2022

Helpful answer

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

Submit an answer

related questions