Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.