Forum Discussion
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...
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.
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