Forum Discussion
Advocate IDates Driving me Crazy
Hi Alboy,
Thank you for reaching out to the Microsoft fabric community forum. Thank you danextian, govind_021, for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.
Dax Measure for Total returns in returns table:Total Returns = SUM(Returns[ReturnAmount])Dax Measure for Total sales in sales table:
Total Sales = SUM(Sales[Amount])Relationship:
Outcome:
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Super UserHi Alboy
If you have multiple active relationships to the same Date table, conflicts can arise. Ensure only one relationship to the Date table is active at a time (Power BI allows only one active relationship). You can manage inactive relationships via DAX using functions like USERELATIONSHIP().
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst
