Create a dax calendar table that start with today's date and ends with 01/01/2015

[Anonymous]

Hello Everyone,

Can anyone help me with creating a new table that starts with today's date every time I refresh the report.

I want to build this because I don't want unwanted dates starting from tomorrow in the Date slicer and I should be able to use between function within the slicer. 

I tried creating a new column with below-given code in a table known as  calendar (generated with calendarauto( ) dax) but then I can't use between a function within the slicer. This code is creating a new column within the calendar table, leaving the date starting from tomorrow as blank. 

Dim_Date = IF(

[Date] = Today(),

"Today",

IF(

'Calendar'[Date]=TODAY(),

"Today",

IF(

'Calendar'[Date]<TODAY(),

'Calendar'[Date]&""

))

)

Please help!

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Bit confusing, you asked for a calendar that starts with today's date but you mean ending with today's date.

Cal = CALENDAR(DATE(2015,1,1), TODAY())

Regards

Phil

[Anonymous]

Hi @PhilipTreacy 

Thank you, Philip. It worked for me.

Cheers!

[mahoneypat]

Did you try to use CALENDAR this way instead of CALENDARAUTO?

NewDateTable = CALENDAR(TODAY(), DATE(2021,12,31))  // put whatever end date your want or calculate it dynamically from your fact table

Pat

[Anonymous]

Hi Pat,

I tried the code it didn't work.
I want to create a calendar table which starts 01/01/2015 and ends today.