Forum Discussion
Solved
How not to exclude data comparing two sets of data with dates
I have two tables: one reflecting budget values, the other reflecting actual values, each with daily values. For ease, let's say each table only has "date" and "unit sales" columns. In my PBI matrix,...
Budget Units =
CALCULATE(
SUM(Budget[Unit Sales]),
REMOVEFILTERS(Actual[Date]), // ignore actuals filter
USERELATIONSHIP(Date[Date], Budget[Date]) // force budget relation
)Actual Units =
CALCULATE(
SUM(Actual[Unit Sales]),
REMOVEFILTERS(Budget[Date]), // ignore budget filter
USERELATIONSHIP(Date[Date], Actual[Date])
))
Matrix: Rows = Date[Month], Values = both measures.
v-menakakota
Community Support
Community SupportHi kgsoto ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank Kedar_Pande , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team
v-menakakotaCommunity Support
Community SupportHi kgsoto ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team