Forum Discussion
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 ...
To get dates to sort in the correct order I used this one
MonthT = FORMAT([Date], "MMM") & " " & [Year])
MonthN = MONTH([Date])
And then sorted by SUM OF MonthN as a value
Edit Actually there is a much better way to do this as shown below
Actually the correct way to do this si shown in this thread