Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
borelza2106
Frequent Visitor

Dynamics Measure Based off two different date slicers

I have two different tables setup for users to indicate Pre vs Post data for water consumption based off two different Date Slicers setup as Between style. The tables work great only because I can edit the interactions between the tables and have one date slicer on one table, and the other on the opposite table. 

 

borelza2106_0-1711384767857.png

 

The issue I am having is I am trying to setup a subtraction measure of the 'Water Use in Gallons' column that is visible in both tables, but I need the measure to update based on what is selected in both date slicers because it will differ per user on whatever account they end up selecting. I don't know if this isn't feasible since all I can come across is using SELECTEDVALUE but that only seems to work on slicers with single select options to help filter. 

So essentially:
MEASURE =

CALCULATE((AVERAGE('Water Use in Gallons'),PreDate Selection) - 

CALCULATE((AVERAGE('Water Use in Gallons'),PostDate Selection)

 

If we look at the above table, this would generate as: 
MEASURE =
1,399,580 - 1,833,671 = -434,091

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@borelza2106 , refer to this

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
borelza2106
Frequent Visitor

@amitchandak thank you so much! It worked perfectly and I am all set. Appreciate the help. 

amitchandak
Super User
Super User

@borelza2106 , refer to this

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors