Forum Discussion

LABrowne's avatar
LABrowne
Icon for Helper II rankHelper II
2 years ago

Creating multiple date hierarchies for Power BI

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

 

 

1 Reply

  • What's the error message?

     

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