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

[Niharika]

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 table with the current value columns and the previous value columns. I want to dynamically change the alternate columns using the two filters respectively. That is like; using date range 1, columns 1 should only change, and using the 2nd date range column 2 will change and so on respectively.

[mahoneypat]

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

[amitchandak]

@Niharika , refer if this can help

https://www.youtube.com/watch?v=cyOquvfhzNM

[Niharika]

Hi Amit,
Thanks, you take the time to give the response to my Query!
I am not looking for something like this, I want to filter my alternate columns using 2 slicers independently.
Although Thanks for the suggested video,  it added up to my learning 🙂

[Anonymous]

Your requirements are not clear. Please refer to this:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best
D