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
2 Replies
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 __ResultYes, it's work. Thank you
