In writing the DAX for the table "dim_Date" after the first argument (<table>), you then refer to this column using [Date] in the following functions: format(), month() and weekday(), I was wondering if this column name is taken from the data type, if it was derived by your typing [Date] or otherwise? Hope you understand my question, thanks!

Hi Callum, Thank you for your question. The way it works is that you are building the column that is [Date] by using the CALENDAR function. Then you are basically calling the Date column that you built using DAX. I hope this helps. Kind Regards, Dimitar Shutev

Follow this topic

Callum Shaw

Last answered:

30 Apr 2021

Posted on:

30 Apr 2021

Resolved: How was dim_Date first column name generated?

in Power BI / Hierarchies

1 answers ( 1 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

30 Apr 2021

Helpful answer

Resolved: How was dim_Date first column name generated?

Submit an answer

related questions