Forum Discussion

Sedos101's avatar
Sedos101
Helper I
3 years ago
Solved

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

  • HoangHugo's avatar
    HoangHugo
    Solution 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)))))))))))))))))))