Not getting the MAX Month Data of latest year

[vidyasagar159]

Hello All,

I have a simple requirement but unable to find the logic here. I am trying to show the MAX month AUM for each year and latest year(2016) i have max month is NOV and for that sales amount is showing zero. Its working fine for the rest of the years.

Also interesting thing is when i select 2016 from filter i am able to see that AUM value.

Here is Measure logic i am using.

=if(rank(sum([Asset Usd]))<=RankNumber,(sum({$<[Monthly AUM]={'=$(=Max([Monthly AUM]))'}>}[Asset Usd])*1000000)/1000000000,0)

Also please find the screenshot below.

[jyothish8807]

Hi Sagar,

Can you create a new expression "Max([Monthly AUM])" and see what month comes for Year 2016 ? I beleive it will show Dec. 

Also can you share share a sample data or your datamodel screenshot ?