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 ...
ImkeF
10 years agoCommunity Champion
Nice trick!
Just came across this blogpost using ADDCOLUMN allowing you to "script" the table-creation, so no need to create every single column manually: http://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/
- Anonymous10 years agoNot applicable
ImkeF thanks so much! awesome :D