DAX date table

[icturion]

Hello,

i'm trying to create a date table based on the date value of a column within a different table.

This is what a got so far:

Date =

ADDCOLUMNS (

CALENDAR (DATE(2010;1;1); DATE(2025;12;31));

"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );

"Jaar"; YEAR ( [Date] );

"Maand nr"; FORMAT ( [Date]; "MM" );

"JaarMnd nr"; FORMAT ( [Date]; "YYYY/MM" );

"JaarMnd kort"; FORMAT ( [Date]; "YYYY/mmm" );

"Maand kort"; FORMAT ( [Date]; "mmm" );

"Maand lang"; FORMAT ( [Date]; "mmmm" );

"Dag van de week nr"; WEEKDAY ( [Date] );

"Dag van de week"; FORMAT ( [Date]; "dddd" );

"Dag van de week kort"; FORMAT ( [Date]; "ddd" );

"Kwartaal"; "Q" & FORMAT ( [Date]; "Q" );

"JaarKwartaal"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" )

)

Regards

ICTURION

[icturion]

Using this DAX i can create a table with one column based on the values in the other table/column:

Datum = CALENDAR(MIN('Sales'[OrderDate]);MAX('Sales'[OrderDate]))

next step is to maken one DAX solution.

[v-cherch-msft]

Hi @icturion 

You may also use CALENDARAUTO Function.If you have other question,please share more details for us so that we could help further on it.If not,please accept the reply as solution to close this thread.

Regards,

[v-cherch-msft]

Hi @icturion 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

[icturion]

Hi,

The problem still exists. I am currently working around it by building the calendar table per calculated column. what i'm actually looking for is one dax code that is derived from a date column in another table.

regards 

icturion