Date hirachy not available

[JensHN]

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 nearby the same DAX formula, one searches for the lowest date value, the other for the highest date value.

In the Visualisation i get the full hirachy for "History Start" with year, month, day, etc. For "History End" is no hirachy available.

On other posts with similar problems the reason was the table connection, but in my case both fields use the same connection.

Any ideas?

[v-yulgu-msft]

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 · Accepted solution]

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.