What I try to do:
Using DAX function LOOKUPVALUE in the same way as VLOOKUP in Excel with the parameter TRUE.
Additional information:
Behavior of VLOOKUP in Excel with parameter TRUE:
VLOOKUP(Value, Range, i, TRUE)
The function looks for the last value in the first column of Range that is not greater than Value, and will return the value in the i-th column on the same row. VLOOKUP requires the data to be sorted in ascending order.
Problem: Unfortunately, DAX LOOKUPVALUE returns the related value only if the search value matches exactly the search criteria. Otherwise, LOOKUPVALUE returns BLANK value.
Specific question: Is there any other DAX function or workaround available having the same behavior as VLOOKUP with parameter TRUE in Excel?