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,

 

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!