Forum Discussion
ALeef
10 years agoResolver II
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 ...
robcrockford
10 years agoAdvocate I
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
10 years agoNot applicable