Forum Discussion
Solved
Dynamic Filtering of table
Hello, Please help. I am trying to dynamically filter a table and adjust based on a date selection. is this possible with DAX?
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])
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])
Hey Anonymous
Thank you for your help. How did you have your relationships set up? It only returns the same exact number for each column.
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...