Rolling Month with maximum day

[panipat1990]

Dear Team,

i stuck a requirement.

i am calculating rolling month 12. But i am want to calculate last 12 month of maximum day data.

Suppose we have data last month1 to 30.and i want to sum of sale only 30's day means max day of the month.Same last 12 month.How is it. Kindly help me.

[pathiqvd]

Hi,

     Try this may be you will get,

=Count({<date_field={">=$(=date(max(date_field)-360))<=$(=date(max(date_field)))"}>}DISTINCT Client_id)

Regards,

[panipat1990]

i want to calculate last Each  month data's of maximum day.Like 30 and 31.

[sunny_talwar · Accepted solution]

May be like this:

=Count({<date_field={"=Day(date_field) = Day(MonthEnd(date_field))"}>} DISTINCT Client_id)