Forum Discussion
Maximum Value from table
Hi everyone, Im having difficulty displaying my maximum value from a table, i would appreciate if anyone could help me. The error shows that " Argument "6" in function SWITCH is required" M...
Hi Anonymous ,
Please note that your code has an extra comma at the underscore I marked:
If you just want to apply a flag for the max and min value, you could simply use:
Column = var _max=MAX('energykwh energydata'[energydata_value]) var _min=MIN('energykwh energydata'[energydata_value]) return SWITCH(TRUE(), [energydata_value]=_max,2,[energydata_value]=_min,1)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please note that your code has an extra comma at the underscore I marked:
If you just want to apply a flag for the max and min value, you could simply use:
Column =
var _max=MAX('energykwh energydata'[energydata_value])
var _min=MIN('energykwh energydata'[energydata_value])
return SWITCH(TRUE(), [energydata_value]=_max,2,[energydata_value]=_min,1)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.