Forum Discussion
LABrowne
Helper II
2 years agoCreating 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
- lbendlin
Super User
What's the error message?
Also - read about inactive relationships. You may not need two calendar tables.