Forum Discussion
Solved
Return range for given value
Hello Experts I have this data table1: I want to result from this table2: This will be a my final result: How i take a range for give data in power bi dax? Thank you.
MHTANK Try:
Range Column in Table1 = VAR __Points = 'Table1'[Points] VAR __From = MAXX(FILTER('Table2', 'Table2'[From] <= __Points),[From]) VAR __Result = MAXX(FILTER('Table2', 'Table2'[From] = __From),[Range]) RETURN __Result
MHTANK Try:
Range Column in Table1 =
VAR __Points = 'Table1'[Points]
VAR __From = MAXX(FILTER('Table2', 'Table2'[From] <= __Points),[From])
VAR __Result = MAXX(FILTER('Table2', 'Table2'[From] = __From),[Range])
RETURN
__Result
Yes, it's work. Thank you