Hello,
I've plotted flow rate values from the same data set to two separate time series charts. I'm able to edit the interactions between the two "between" date slicers to sum the resulting quantities over these separate time periods using two measure calculations. Is there a way to subtract these two values, based on the slicer time periods set and display on a card? The result should be (Wet Weather Flow - Dry Weather Flow) = Flow Difference = (2.84M - 336.4k = 2.5M) See below:
Any suggestions or useful links on how to create a measure based on the output of two date between date slicers is much appreciated!
@Anonymous it should be straight forward, add new measure
Flow Difference = [Wet Weather Flow Measure] - [Dry Weather Flow Measure]
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous it should be straight forward, add new measure
Flow Difference = [Wet Weather Flow Measure] - [Dry Weather Flow Measure]
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
