Forum Discussion

kobe's avatar
kobe
Frequent Visitor
3 years ago

custom data hierarchy issue

I create a custom date hierarchy in order to have more selections such as weeknum and weekday. The conlumn of month (Januray, Feburary...) and weekday (Monday Tuesday...) are in Text format. They cou...
Need Help
ToddChitt's avatar
ToddChitt
Super User
3 years ago

In your Date table, add columns for WeekDay (INT, 1 - 7) and MONTH (1-12). Then for the Week day name and month name columns, use the Sort By option (on the Column Tools menu) to sort those column by their respective integer columns.

In your visual, if you sort the X axis by Month Name, it will use the 1, 2, 3, etc. values from the Month Number column

kobe's avatar
kobe
Frequent Visitor
3 years ago

Thanks for your fast response.

 

I actually create the custom date hierarchy inside my master table as the separate date table isn't working for some reasons. It seems I have no other options. 

  • ToddChitt's avatar
    ToddChitt
    Super User
    3 years ago

    Seriously, you should have a Date Dimension table in your model. Let's start there. Use this DAX statement to get started with a new table.

    MyDates = CALENDAR("01/01/2020", "12/31/2024")

    Then join that to your 'master data table' on the dates