How to get max of month year?

[karthikeyan1504]

Hi,

I have a date field in the main table. I have derived the month year from the main table using the default master calendar script.

Now I need to get the latest month-year for my set analysis expressions.

Could anyone please advise me to get the latest month-year?

Thanks & Regards,

Karthikeyan.

[jagan · Accepted solution]

Hi,

you can simply use the below set analysis expression for this,

=Sum({<Year=, Month=, Date={'>=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[jagan]

Check for similar set analysis expressions from below link

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Regards,

Jagan.

[karthikeyan1504]

Hi Jagan,

It's working perfectly, but I still have difficulty to get the value of last month year value.

Subtracting with -30 or -31 will be difficult in set analysis.

Thanks & Regards,

Karthikeyan.

[jagan]

Hi,

Use below to get last month value

=Sum({<Year=, Month=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>} Sales)

Regards,

Jagan.

[karthikeyan1504]

Hi Jagan,

I have got the sales value for last month year. I need to display the month year such as 'Dec-15' vs 'Jan-16' below the KPI to indicate.

[jagan]

Hi,

I am not sure what you are trying to do.  How you want to display the values?

Regards,

Jagan.

[karthikeyan1504]

I am sorry... I have got confused. I have got it from the above expression itself

Thanks much for your help!!!

[jagan]

Ok fine.

Regards,

Jagan.

[anushahegde]

You saved me. Thanks!!