Forum Discussion

kobe's avatar
kobe
Frequent Visitor
3 years ago
Solved

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...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    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 

kobe's avatar
kobe
Frequent Visitor
3 years ago

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.

 

 

Idrissshatila's avatar
Idrissshatila
Super User
3 years ago

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 

  • kobe's avatar
    kobe
    Frequent Visitor
    3 years ago

    Just to double confirm that you mean converting data type of both conlumns from "Date/time" to "Date"? Anyway I will try it tomorrow.