Last answered:

30 Apr 2021

Posted on:

30 Apr 2021


Resolved: How was dim_Date first column name generated?

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!

1 answers ( 1 marked as helpful)
Posted on:

30 Apr 2021


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

Submit an answer