how to get last year June value while selecting months between 1-6 months and same year June value while selecting 7-12 months in date parameter.?

Hi Ken,

Thanks for asking.

I attached a sample workbook and I was unable to fix the 3rd column.

It is based on the Month parameter and finds the below approach.

Kindly suggest accordingly.

*Prior Financial Year June (Third Column):*

If I selected <=6 months in para need to get a Previous year June value

and If I selected >=7 months in para need to get a same year June value

Find Approach:

Selected Month Prior Month Prior Fin Year June Prior Year

[image: image.png]

Kind Regards,

Bommana Gayathri.