Forum Discussion

ALeef's avatar
ALeef
Resolver II
10 years ago

Possible Tip/Trick: Dynamic Date Dimension Table

I'm going to share the dynamic date dimension table I built, hopefully it is useful to someone!  I named it DateTable for this tutorial, and my fact table FactTable.   The table is built using the ...
Tips and Tricks
GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

I am probably missing something but when I enter the DateTable = CALENDAR (MINX('FactTable', [Created Date]), NOW()) in a new table it says it cant find FactTable. I changed this to a table I had imported and then it says Created Date cannot be found.

 

I am very new to DAX so would appreciate if you could explain a bit further please as this looks very useful.

 

Thanks,

  • RJ's avatar
    RJ
    Resolver II
    10 years ago

     

    Did you put for minx 

     

    1 The table name   'Account Transactions', 

    2  The field name    'Account Transactions'[Date]) ,

     

    DateTable = CALENDAR(              minx (     'Account Transactions',      'Account Transactions'[Date]     ) ,         today ())

  • ALeef's avatar
    ALeef
    Resolver II
    10 years ago

    GilesWalker : [Created Date] refers to a field in my Fact Table, so you will have to change your field name to something that has a date in it.