Date Hierarchy Disappears when Connected to Another Date field

[Anonymous]

I'm trying a replicate another dashboard I had that involves a relationships between two date fields to measure an email open rate.

I've been able to successfully set this up in the past, but for some reason, I can't get it to work this time...

Essentially this is how the date relationship plays out when I link them, they're both "Date" type fields:

Obviously Dec 2, 2019 IS NOT equal to January, 2020.

I noticed that the Date Hiearchy symbol dispears from my original date that I'm trying to relate to the date table when I make this connection. 

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft · Accepted solution]

Hi ， @Anonymous 

It will be convenient for us to solve your problem  if you  can share your screenshoot about your table relationship in model view.
Whether an active relationship between tables is established based on these two fields  （ "senddate" and  "date"）?

When you establish a relationship , the original date field hierarchy  (Date Hiearchy symbol ) disappears is intended behaviour.

In this case you need use date field from date table to work in your visuals.

Before :

After building  relationship

Best Regards,
Community Support Team _ Eason

[parry2k]

@Anonymous not sure what is your question, can you please provide sample data and what you are trying to achieve. if you have two date table and relationship to a date table, It is ok to have an inactive relationship, you can have only one active relationship between tables, to use inactive relationship in your calculation, use userelationship function.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡