Measure filtered by 2 separate dynamic date slicers

DAX DAX Calculations
1

Hi,

I am trying to figure out if it is possible to create a measure on a numeric column that can be dynamically filtered by two independent date slicers. The example would be taking values from 2.1.2020 - 5.30.2020 & taking values from 6.1.2019 - 10.15.2019 and have them added in a single measure I can report out on. I am trying to use the PY values as a proxy for the CY. To be clear, I am not trying to incorporate stagnant dates in a filter formula, but have them be dynamic based on 2 date slicers on my visual.

2

@wscarter,

Welcome to the forum – great to have you here!

The way I would handle this is using two slicers associated with two disconnected tables. Each disconnected table will be created by a DAX expression along the lines of:

Disconn Date1 = VALUES( Dates[Date] )

You can then harvest the values from the disconnected tables by

Harvest Disconn1 = SELECTEDVALUE( Disconn Date1[Date] )

These harvest measures then become the filter conditions in your CALCULATE statement.

Hopefully that’s clear. If not, please provide a sample PBIX and I will be glad to craft a more specific solution.

  • Brian
1 Like
3

Brian,

Excellent idea. I always forget about this technique. I will try this out & post back if furthur assistance is needed.

Thanks again!

4

It’s great to know that you are making progress with your query @wscarter. Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!