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.
Advocate IThanks for that. I have tried however the filtering only works on the Period Plan table - evrything from Order2Install table is omitted:
I can work around by just deleting all relationships and adding filters for each table - just a little bit messy is all but looks like I'll need to move on and just do that 🙂 Thanks all for the assist 🙂
Advocate II take it back - I used a new data table (like yours) as opposed to the generic one I use (which combines data with period, Financial Period etc) and it worked perfectly - thank you!