Comparing data in the same column using slicers

[adamdyas]

I have a table that is updated daily.  Each update includes a snapshot date.  I've duplicated the table and created visualization that allow a user to select and view the data for a snapshot date in one table and the data for a second snapshot date in another.  I'm trying to create a third table that dynamically calculates the difference between the values selected by the slicers.

An example of the table is below.  Put plainly, I'm looking for a solution where the user can select a snapshot date of "3/19/25" in the first slicer and see the corresponding data.  Select "3/20/25" in the second slicer and see the corresponding data.  And then a third table that finds matches between the "Week Starting" and "Attribute" in the filtered datasets and calculated the difference of "Value Pounds".

Thaks.

[v-ssriganesh · Accepted solution]

Hi @adamdyas,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @amitchandak for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[amitchandak]

@adamdyas , You should Snapshot date with a Date of date table with Active join, Have inactive week Staring. This can be used using userelationship if you want to use same date slicer.

When you want different, you date from date tbale for snapshot date, have week start slicer from the fact.  That should work

In your approach you can have measure from fact countrows(Fact), and use that measure level filter to reduce the dates, if you have two date dimensions 

https://www.youtube.com/watch?v=cyOquvfhzNM