max day of every month

[ilanbaruch]

hi all,

i have a pivot with year and month as dimensions ,

in one of the expressions i try to calculate sum amount of the last / max day of the month, any ideas ?

‌

[sunny_talwar · Accepted solution]

May be something like this:

FirstSortedValue(Aggr(Sum(Sales), Date), -Aggr(Max(Date), Date))

[sunny_talwar]

Should also work if you have Month and Year as two dimensions instead of one

[ilanbaruch]

Thank you Sunny, it worked!

[sunny_talwar]

No problem. I am glad I was able to help you