Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you check what do you get in a KPI object when you use this
=Max(MonthNo)
MonthNo is a numeric field or text field or date field?
Numeric only
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?
no its single only.
because I have one more dimesion added in the table. so its showing for all values.
Can you check what do you get in a KPI object when you use this
=Max(MonthNo)
kpi object also same number it is displaying
This might sound stupid... but do you have Amount for Feb?