Forum Discussion

JensHN's avatar
JensHN
Frequent Visitor
7 years ago
Solved

Date hirachy not available

Hi,   I have two tables "Jobs" and "History" with a 1:n connection. In the Jobs table are two calculated columns "History Start" and "History End". Both colums are declared as datetime and have ne...
Need Help
  • JensHN's avatar
    JensHN
    7 years ago

    Hi v-yulgu-msft,

     

    thank you very much for your fast reply and your effort in rebuilding my data construction.

    I´m sorry that i can´t post some sample data, it´s because they contain to many internal informations. My hope was that there is a simple solution just like "tick the box for date hirachy".

     

    As a "quick and dirty" solution i deleted the two calculated columns, created them new and pasted the same DAX formula. Everything like before. Now the hirachy is available, i don´t know why but it works.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi JensHN,

 

Below is the result in my test, both [History Start] and [History End] shows hierarchy in table visual.

Sample data.

 

Relationship.

 

Report view.

 

I was not able to reproduce your scenario. Please provide sample data and make it more clear that how is the relationship built. How to Get Your Question Answered Quickly

 

Best regards,

Yuliana Gu

  • JensHN's avatar
    JensHN
    Frequent Visitor
    7 years ago

    Hi v-yulgu-msft,

     

    thank you very much for your fast reply and your effort in rebuilding my data construction.

    I´m sorry that i can´t post some sample data, it´s because they contain to many internal informations. My hope was that there is a simple solution just like "tick the box for date hirachy".

     

    As a "quick and dirty" solution i deleted the two calculated columns, created them new and pasted the same DAX formula. Everything like before. Now the hirachy is available, i don´t know why but it works.