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
robcrockford's avatar
robcrockford
Icon for Advocate I rankAdvocate I
10 years ago

Hi, new to PBI, when you say:

 

"The table is built using the following formula:

DateTable = CALENDAR (MINX('FactTable', [Created Date]), NOW())"

 

Where should this formula be added? Assume you create the column headers for the rest and add formulas into row 1?

 

Thanks in advance

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

robcrockford please see picture below :)