Forum Discussion

Niharika's avatar
Niharika
Regular Visitor
6 years ago

Is it possible to link two date range filter with the same table?

Hi, I'm trying to make my table columns dynamic. Can you please let me know if it is possible directly or using Dax? The scenario is like I want to add two date range on my page, there I am showing a...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

If I understand what you are trying to do correctly, the following approach might work.

 

1. Make two calculated DAX tables, both with the same expression - FilterDates1 = Values(OriginalTable[Date]) and same for FilterDates2

2. Add each of the new Date columns as slicers to your report

3. Write two measures like this - MeasureWithFilter1 = Calculate([MyMeasure], TREATAS(Values(FilterDates1[Date]), OriginalTable[Date]))

4. Add the two measures to your visual

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat