Forum Discussion
Comparing data in the same column using slicers
Hi Anonymous,
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.
Anonymous , 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