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
ALeef's avatar
ALeef
Icon for Resolver II rankResolver II
10 years ago

konstantinos has it right.  I made it using the New Table option on the ribbon.

ALeef's avatar
ALeef
Icon for Resolver II rankResolver II
10 years ago

I edited the table above to inclue ISO Week number, which also helped fix the Week Ending values.  Should be more accurate now.  Please let me know if you figure out how to break it!