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!
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.
Hi cocoloco79,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi, I created a combined table, inculding the many to many relationship.
BI_Date = CALENDAR(date(2024,01,01), date(2028,12,31))Many to many relationship is causedn as the calendar is exeeding todays date, I believe.
Is there a function to increase the dates as the dataset grows?Anyways, even with the many to many relationsp, the table works correctly now.