Dynamic Filtering of table

[TexasBI]

Hello, 

Please help. I am trying to dynamically filter a table and adjust based on a date selection. is this possible with DAX?

[Vera_33 · Accepted solution]

Hi @TexasBI 

If you add another disconnected Date table, I am using NewDate in the Slicer, original Date in the visual, or modify the measure2 otherwise

Measure 2 = 
VAR CurDate = SELECTEDVALUE('Date'[Date])
VAR CurNewDate = SELECTEDVALUE(NewDate[Date])
RETURN
IF(CurNewDate in DATESBETWEEN('Date'[Date],EDATE(CurDate,-1),EDATE(CurDate,1)),[Measure])

Measure 2 = 
VAR CurDate = SELECTEDVALUE('Date'[Date])
VAR CurNewDate = SELECTEDVALUE(NewDate[Date])
RETURN
IF(CurNewDate in DATESBETWEEN('Date'[Date],EDATE(CurDate,-1),EDATE(CurDate,1)),[Measure])

[TexasBI]

Hey @Vera_33 

Thank you for your help. How did you have your relationships set up? It only returns the same exact number for each column.

[Vera_33]

Hi @TexasBI 

I have a Date table connects with that 3 tables like your screenshot, another Disconnected newDate table, my dummy data is all the same values for every month in every table...