Forum Discussion

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

How to handle two fact tables with different date range

Hi I have two separate PBI models, one for Sales and one for SalesBudget. Both has financial year September to August.   In my Sales PBI model : I created the Fiscal Calendar using Calendarauto (...
Need Help
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Aixia 

 

 


Try the above modeling. 
create Fiscal Calendar with Sales date column.
Make 1 to many relationship from fiscal cal to sales table and fiscal to sales budget table.

Connect both the tables with Date column.

 

I hope it may resolves your issue!

 

  • Aixia's avatar
    Aixia
    Icon for Helper II rankHelper II
    2 years ago

    Hi Uzi2019 

    Thanks for your quick reply. 

    Below is the relationshops between them from my file.  I think they have the conditions as you said?! But it didn´t work. 

     

     

    Br/Aixia

    • Uzi2019's avatar
      Uzi2019
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi Aixia 
      Try to change the relationship in cross filter direction to both.

       

       

      I hope it helps!

       

      • Aixia's avatar
        Aixia
        Icon for Helper II rankHelper II
        2 years ago

        Hi Uzi2019 

        Thanks for your reply. 

        When I changed the relationship to both, the value of Sales was gone. ie. no values from Sales and SalesBudget.

        Regards

        Aixia