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