Dates Driving me Crazy

Iave two tables in a semantic model and am trying to create a relationship based on date fields but no matter how I set it up - if i try to filter in the report - my report tables either lose all dat...

Need Help

v-kpoloju-msft
1 year ago
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.
PowerBI_DateModel_Template.pbix45 KB

danextian

Super User

1 year ago

Hi Alboy

Can you pleast post a screenshot of our diagram and explain which one only gets filtered ( only filter one side of the relationship )? Also, do the dates in table 1 cover all the dates in table 2 and are they really both dates? One could be a datetime.