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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors