Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
Solved! Go to Solution.
@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
| User | Count |
|---|---|
| 44 | |
| 35 | |
| 30 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 65 | |
| 57 | |
| 40 | |
| 21 | |
| 20 |