Forum Discussion

ALeef's avatar
ALeef
Icon for Resolver II rankResolver 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
Icon for Skilled Sharer rankSkilled 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
Icon for Resolver II rankResolver 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 ())