Forum Discussion
The MAX function only accepts a column reference as an argument
Hi Everyone
I have a column in a table Data[MANAGEMENT_PT] and I am trying to grab the max value for that then apply some conditions in DAX to return some values. When I put in my code however I keep getting the following error:
The MAX function only accepts a column reference as an argument.
HRI = if (MAX(Data[MANAGEMENT_PT])=0,1,
(if (MAX(Data[MANAGEMENT_PT]=1) || MAX(Data[MANAGEMENT_PT]=2),2,
(if (MAX(Data[MANAGEMENT_PT]=3) || MAX(Data[MANAGEMENT_PT]=4),3,
(if (MAX(Data[MANAGEMENT_PT]=5) || MAX(Data[MANAGEMENT_PT]=6),4,
(if (MAX(Data[MANAGEMENT_PT]=7) || MAX(Data[MANAGEMENT_PT]=8),5,
(if (MAX(Data[MANAGEMENT_PT]=9) || MAX(Data[MANAGEMENT_PT]=10),6,
(if (MAX(Data[MANAGEMENT_PT]>=11) && MAX(Data[MANAGEMENT_PT]<=13),7,
(if (MAX(Data[MANAGEMENT_PT]>=14) && MAX(Data[MANAGEMENT_PT]<=16),8,
(if (MAX(Data[MANAGEMENT_PT]>=17) && MAX(Data[MANAGEMENT_PT]<=19),9,
(if (MAX(Data[MANAGEMENT_PT]>=20),9,0)))))))))))))))))))
Does anyone know what is wrong with my formula?
Thanks in advance
Hi, use right Opening and Closing () to MAX function, like below
HRI = if (MAX(Data[MANAGEMENT_PT])=0,1,
(if (MAX(Data[MANAGEMENT_PT])=1 || MAX(Data[MANAGEMENT_PT])=2,2,
(if (MAX(Data[MANAGEMENT_PT])=3 || MAX(Data[MANAGEMENT_PT])=4,3,
(if (MAX(Data[MANAGEMENT_PT])=5 || MAX(Data[MANAGEMENT_PT])=6,4,
(if (MAX(Data[MANAGEMENT_PT])=7 || MAX(Data[MANAGEMENT_PT])=8,5,
(if (MAX(Data[MANAGEMENT_PT])=9 || MAX(Data[MANAGEMENT_PT])=10,6,
(if (MAX(Data[MANAGEMENT_PT])>=11 && MAX(Data[MANAGEMENT_PT])<=13,7,
(if (MAX(Data[MANAGEMENT_PT])>=14 && MAX(Data[MANAGEMENT_PT])<=16,8,
(if (MAX(Data[MANAGEMENT_PT])>=17 && MAX(Data[MANAGEMENT_PT])<=19,9,
(if (MAX(Data[MANAGEMENT_PT])>=20,9,0)))))))))))))))))))
1 Reply
- HoangHugoSolution Specialist
Hi, use right Opening and Closing () to MAX function, like below
HRI = if (MAX(Data[MANAGEMENT_PT])=0,1,
(if (MAX(Data[MANAGEMENT_PT])=1 || MAX(Data[MANAGEMENT_PT])=2,2,
(if (MAX(Data[MANAGEMENT_PT])=3 || MAX(Data[MANAGEMENT_PT])=4,3,
(if (MAX(Data[MANAGEMENT_PT])=5 || MAX(Data[MANAGEMENT_PT])=6,4,
(if (MAX(Data[MANAGEMENT_PT])=7 || MAX(Data[MANAGEMENT_PT])=8,5,
(if (MAX(Data[MANAGEMENT_PT])=9 || MAX(Data[MANAGEMENT_PT])=10,6,
(if (MAX(Data[MANAGEMENT_PT])>=11 && MAX(Data[MANAGEMENT_PT])<=13,7,
(if (MAX(Data[MANAGEMENT_PT])>=14 && MAX(Data[MANAGEMENT_PT])<=16,8,
(if (MAX(Data[MANAGEMENT_PT])>=17 && MAX(Data[MANAGEMENT_PT])<=19,9,
(if (MAX(Data[MANAGEMENT_PT])>=20,9,0)))))))))))))))))))