Forum Discussion
Solved
Select a value from a column based on another value from column.
I would like a measure that will select the the [Target -21/22] value based on the last value in the [21/22 - YTD] column. Can I get help with DAX that would acheiev this?
Ha yes, indeed
what about this approach instead :Measure = VAR _Lastdate = CALCULATE( MAX( YourTable[Date] ), ALL( YourTable[Date], YourTable[Month] ), YourTable[21/22 - YTD] > 0 ) RETURN CALCULATE( MAX( YourTable[Target - 21/22] ), YourTable[Date] = _LastDate )
