Forum Discussion

ALeef's avatar
ALeef
Resolver 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
weilip1803's avatar
weilip1803
Frequent Visitor
10 years ago

I am having a problem, The formula above that I had used is sumerizing the data. How can I avoid the summary. The ordering of the column in charts are sorting the month names by alphabetical order how can i make it go by chronological order?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    weilip1803

     

    It may not be elegant but I have added a 'MonthSort' column to my table

     

    MonthSort = DateTable[Year]&IF(DateTable[MonthofYear]<10,0,"")&DateTable[MonthofYear]

     

    Then simply select the column you're using on the chart in the data tab, click 'modeling' and select the 'Sort by Column' button

     

    Let me know how that goes :)

     

     

    • weilip1803's avatar
      weilip1803
      Frequent Visitor
      10 years ago

      Yea got it.Thanks ^^