Forum Discussion
Custom Data Table Not Working
In order to add Week to date hierarchy, I create a table and add four columns. Then I create the hierarchy and add them to it.
I mark the table as a date table and add a relationship with the "export" table.
This table isn't still working like the auto date hierarchy in the "export" table. Anything is missing?
Hello kobe ,
can you try cinverting both columns into date type.
the date in export table is should be converted to date type in power query.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡the
6 Replies
It's working when I create the custom date hierarchy in the "export" table.
Hello kobe ,
can you make sure that both date columns have the same data type, like both date .
and make sure the the export table has the same data type in power query.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡I confirm both columns have the same Data type which is Date/time with the same format. When I create the custom data hierarchy in Date Table, the auto-generated one in the export table disappears.
I create a custom one within export table and it's working but the order of date legend is sorted.
