Forum Discussion

harryli's avatar
harryli
Icon for Helper II rankHelper II
4 years ago

the max formula is not taking the max. value

Dear all,

the power query editor data:

the formula is :

Max_consult_time = CALCULATE(MAX(dashbd_reg_count_time[current_minus_consult]))
 

the dashboard is:

 

as you may see the max is not taking the max. value.

 

Need Help

1 Reply

  • Smalfly's avatar
    Smalfly
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hi harryli ,

     

    Looks like the max function is treating the initial column as text while you see it as something numeric.

    Can you try to change the format of your original 'current_minus_consult' column to whole number/decimal number?