Max Month order amount

[sspawar88]

Hi community,

Why following Expression is not showing result..is it any mistake in it?

sum({$<Month1={$(=max(Month1))}>}[Order Amount])

[kavita25]

Try this:

num((SUM({< Month1=, Month1={'$(=Maxstring(Month1))'}>}[Order Amount])),'#.##')

[sspawar88]

Thank you very much kavita

[kavita25]

Ur welcome