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
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 46 | |
| 36 | |
| 27 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 59 | |
| 55 | |
| 38 | |
| 21 | |
| 20 |