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
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.