Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, I am trying to add a DAX column to find out the MAX value among few columns, meanwhile, less then the baseline value.
Baseline | A | B | C | MAX_R | |
10 | 7 | 9 | 12 | 9 | |
13 | 10 | 12 | 11 | 12 | |
15 | 14 | 18 | 20 | 14 | |
19 | 17 | 13 | 25 | 17 |
Line 1 in the MAX column, "9" is the largest value among A, B ,C and <10
I am trying this formula but not success. May I have some advice?
MAX_R =
VAR _list = {
('table'[A]),
('table'[B]),
('table'[C])}
return
MAXX(FILTER(_list.[value]<'table'[Baseline]))
Solved! Go to Solution.
@ngct1112 , Test as
Column MAX_R =
maxx(Filter(Union(Row("A",'Table'[A]),Row("A",'Table'[B]),Row("A",'Table'[C])),[A] <=[Baseline]),[A])
@ngct1112 , Test as
Column MAX_R =
maxx(Filter(Union(Row("A",'Table'[A]),Row("A",'Table'[B]),Row("A",'Table'[C])),[A] <=[Baseline]),[A])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |