Max is not working

[soniasweety]

Hi all,

I have  monthno field

so I have data till feb    but feb data is showing zero

till jan it worked.

sum({<MonthNo={$(=Max(MonthNo))},CB={'st','OS'}>}[Amount])

so is there any other way to get it?

[sunny_talwar]

MonthNo is a numeric field or text field or date field?

[soniasweety]

Numeric only

[sunny_talwar]

Is this a filter box you have posted an image of? The reason I ask is because the number 43132 keep on repeating... which makes me think if MonthNo has a decimals in it?

[soniasweety]

no its single only.

because I have one more dimesion added in the table. so its showing for all values.

[sunny_talwar · Accepted solution]

Can you check what do you get in a KPI object when you use this

=Max(MonthNo)

[soniasweety]

kpi object also same number it is displaying

[sunny_talwar]

This might sound stupid... but do you have Amount for Feb?