https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-multiple-date-hierarchies-for-Power-BI/m-p/3733726#M145518 <P>What's the error message?</P> <P>&nbsp;</P> <P>Also - read about inactive relationships.&nbsp; You may not need two calendar tables.</P> Thu, 29 Feb 2024 14:07:29 GMT lbendlin 2024-02-29T14:07:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-multiple-date-hierarchies-for-Power-BI/m-p/3733218#M145494 <P>Hello,</P><P>&nbsp;</P><P>I am currently building a live Power BI report based on Direct Query (live connection).</P><P>&nbsp;</P><P>I have 2 dates InceptionDate &amp; 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.</P><P>&nbsp;</P><P><img /></P><P>Any work arounds would be great!</P><P>&nbsp;</P><P>Thanks,</P><P>luke</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 29 Feb 2024 10:08:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-multiple-date-hierarchies-for-Power-BI/m-p/3733218#M145494 LABrowne 2024-02-29T10:08:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-multiple-date-hierarchies-for-Power-BI/m-p/3733726#M145518 <P>What's the error message?</P> <P>&nbsp;</P> <P>Also - read about inactive relationships.&nbsp; You may not need two calendar tables.</P> Thu, 29 Feb 2024 14:07:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-multiple-date-hierarchies-for-Power-BI/m-p/3733726#M145518 lbendlin 2024-02-29T14:07:29Z