Forum Discussion
Working with two datasets
Hi cocoloco79,
Hi ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If our response addressed by the community member for your query, please mark it as Accept Answer and give us Kudos. Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi cocoloco79, what are you using for your relationship? Date or WeekStartDate? And what do you have in your fact table?
Also, why the other relationships are inactive? The dotted ones
Hi MattiaFratello ,
Releationship is between WeekStartDate, the other tables are not part of what I'm tring to do.
bi_budget table holds budgeted kilos by week, crop and crop type.
bi_dashboard table holds all the sales data, which I'm trying to match by crop, crop type and week start date.
Any suggestion on how to aproach this? creating a combined table perhaps? I'm not sure
Why your relationship btw bi_dashboard and bi_date is many to many? Can you show me this relationship? Can you open it for me and make a screenshot?
Hi cocoloco79,
Happy to see you here in the Microsoft Fabric Community!
The doubling of Sold Kg values is caused by the many-to-many relationship between your bi_dashboard and bi_date tables on Week Start Date. To fix this, ensure your bi_date[Week Start Date] column contains unique dates (no duplicates) and both fact tables have matching date formats for their Week Start Date fields.
Then, delete the current many-to-many relationship and recreate it as a one-to-many relationship with bi_date on the “one” side and your fact tables on the “many” side. This setup will allow proper filtering without duplications.
If you still need to analyze budget and actual sales together, consider combining these tables into a single fact table with an indicator column. Please try adjusting the relationships this way and check if Sold Kg aggregates correctly. Let me know if you need help with this.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Thank you,
Sahasra.