the max formula is not taking the max. value

[harryli]

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.

[Smalfly]

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?