Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Please help. I am trying to dynamically filter a table and adjust based on a date selection. is this possible with DAX?
Solved! Go to 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])
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 @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.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |