Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

multipe many to many tables issue

Hi,

 

I have 3 many to many tables , 2 are transaction table (budget & actual)& 1 is master table so to avoid this issue i created a bridge table , now i have one to many relationship with all 3 tables but the output value is incorrect .

In modeling side I have created date table & joined it with budget & actual table , then I created a bridge table & mapped it with 3 tables (actual , budget & master), but output value is incorrect (actual with bridge relationship is single , budget & bridge relationship is single whereas bridge & master relation is both)

 

 

so this is value i'm getting in ytd bud vs act report whereas the value in base data is act value & bud value required output

Need Help

1 Reply

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    4 years ago

    Hey Anonymous ,

     

    here you will find a pattern that is using multiple fact tables (act and budget), also with different granularity: https://docs.microsoft.com/en-us/power-bi/connect-data/service-template-apps-overview

     

    Consider creating a pbix file with sample data, that still reflects your data model (tables, calculated columns, relationships between tables, measures). Upload the pbix to onedrive or dropbox and share the link. If you use Excel to create the sample data instead of the manual input method, share the xlsx as well.

     

    Regards,

    Tom