how to get the latest full month

[Anonymous]

How to get latest full month. If latest date is 16 march 2017  then period should show Feb 2017. i.e. latest full month

[sunny_talwar]

May be like this

Sum({<Date = {"$(='>=' & Date(If(Max(Date) = Floor(MonthEnd(Max(Date))), MonthStart(Max(Date)), MonthStart(Max(Date), -1)), 'DateFieldFormatHere') & '<=' & Date(If(Max(Date) = Floor(MonthEnd(Max(Date))), Floor(MonthEnd(Max(Date))), Floor(MonthEnd(Max(Date), -1))), 'DateFieldFormatHere'))"}>}Measure)

[antoniotiman · Accepted solution]

May be

Max(MonthEnd(Date),2)

or

MonthName(Max(MonthEnd(Date),2))

Regards,

Antonio

[Anonymous]

try

MonthName(MonthEnd(YOURDATEFIELD,-1))

[Anonymous]

Thank you.