I want to find Last day of every Month closing balance

[chinnu123]

Hello Everyone,

I am having a one scenario like finding a every month last date closing balance.

Using Month year as a Dimension.

Using  Date  field need to find Last date Closing balance  for every month.

Can anyone help me to find some solution for this.

Thanks,

Chinnu.

[MayilVahanan]

Hi @chinnu123 

Try like below
Sum({<Date={"=Date=DayName(MonthEnd(Date))"}>}YourExpfield)
-- above will give month end date info.

Sum({<Date={$(=chr(39)&Concat(Aggr(Max(Date),MonthYear),chr(39)&','&chr(39))&chr(39))}>}YourExpfield)

- Above will give max date of that particular month.