MAX(Scalar1, Scalar2) Function doesnt work in Excel 2013?

[pociners]

Hey everyone,

Does anybody know why MAX(Scalar1, Scalar2) Function in PowerPivot Excel 2013 is not working?
PowerPivot Excel 2013 only know MAX(Column) Function.
Currently I use Excel 2016, but when i create a Measure and calculated column using MAX(Scalar1, Scalar2) and open it in Excel 2013, it always shows error..

Can anybody help me how to fix this?

Thanks

 

[pociners]

Well, at the end I use

IF(Scalar1 < Scalar2, Scalar2, Scalar1)

to replace <scalar2,scalar2,scalar1) to="" replace="" <scalar2,scalar2,scalar1)[="" code]="" <font="" color="#333333">MAX(Scalar1, Scalar2) Function,haha</scalar2,scalar2,scalar1)>