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 m...
Need Help
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?