Forum Discussion

Sedos101's avatar
Sedos101
Icon for Helper I rankHelper 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 ...
Need Help
  • HoangHugo's avatar
    HoangHugo
    3 years ago

    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)))))))))))))))))))

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
3 years ago

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)))))))))))))))))))