Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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
Proud to be a Super User! | |
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💡
Proud to be a Super User! | |
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.
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
Proud to be a Super User! | |
Just to double confirm that you mean converting data type of both conlumns from "Date/time" to "Date"? Anyway I will try it tomorrow.
@kobe , Yes.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |