Forum Discussion
Fixing Filter Measure
Hi all, I'm trying to use the below measure to lookup a value in a table where I have a unique code VAR Selected_Date = 'Table1'[Date] RETURN LOOKUPVALUE ( FILTER('Table1', Selected_Dat...
Hi,
Please use min/max date in the variable, if you are using measure then this would dynamically filter to the selected period
VAR Selected_Date = MAX('Table2'[Date])
RETURN
LOOKUPVALUE(table1[value] , table1[date] , Selected_Date ,table1[uniqueid] , table2[uniqueid])
It doesn't let me reference table1[value] in this. It only lets me reference Table2 columns or the relationship table the code's are linked by.