Creating multiple date hierarchies for Power BI

[LABrowne]

Hello,

I am currently building a live Power BI report based on Direct Query (live connection).

I have 2 dates InceptionDate & DateofLoss. They are both in seperate policy and claim tables respectively. I have created 2 calendar tables manually and connect DateofLoss with the Claims Calendar. That works and I have a date hierachy. I cannot do the same for the policy table and InceptionDate as I get an error message saying Below is what I've created thus far.

Any work arounds would be great!

Thanks,

luke

[lbendlin]

What's the error message?

Also - read about inactive relationships.  You may not need two calendar tables.