Forum Discussion

RohithGn's avatar
RohithGn
Helper I
8 years ago
Solved

Dynamic Dim date table - Dax

Hi,   I am trying to create a Dimdate table in power bi and the table should contain all dates from today's month last year till today. I have used CALENDAR(DATE(YEAR(TODAY()),MONTH(TODAY())-13,DAY...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    I just copied this statement from sample table, on a 2nd look I realized that the CALENDAR(<Startdate>, <Enddate>) function was missing, but now it's complete

    Table = CALENDAR(
DATE(YEAR(TODAY())-1,MONTH(TODAY()),1), TODAY())

     

    Regards

    Tom

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

try this

CALENDAR=
DATE(YEAR(TODAY())-1,MONTH(TODAY()),1), TODAY())

Hopefully this is what you are looking for

 

Regards

Tom

RohithGn's avatar
RohithGn
Helper I
8 years ago

Hi Tom,

 

Thanks for quick response however I am getting an error. Played around with the braces still no luck 

 

Regards,

Rohith 

 

 

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    I just copied this statement from sample table, on a 2nd look I realized that the CALENDAR(<Startdate>, <Enddate>) function was missing, but now it's complete

    Table = CALENDAR(
DATE(YEAR(TODAY())-1,MONTH(TODAY()),1), TODAY())

     

    Regards

    Tom

    • RohithGn's avatar
      RohithGn
      Helper I
      8 years ago

      Works as expected Thanks a ton!