Forum Discussion
ALeef
Resolver II
Resolver IIPossible 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 ...
RJResolver II
Resolver II
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
- RJ
Actually the correct way to do this si shown in this thread