Master calendar month number issue

[arpitkharkia]

Hi all,

I have a master calendar ranging from Jan-2017 to December-2018. I have generated month number for all the 24 months. The problem i am facing is that Max(MonthNumber) gives me Dec-18, but i want to point at the current month that is Jan-18.

Is there a way i can identify the month number of current month which i can use in set analysis?

Thanks!

[sunny_talwar]

Yes, it should be... but select month ranges within the expression or for selections?

[arpitkharkia]

Within expressions. Actually i have done something and its working.

Any alternate/efficient way would be appreciated!

[sunny_talwar]

What have you done? May be we can make changes to what you already have? Will also give me an idea of what you might be looking for

[sunny_talwar]

Also, once you have what you needed, please close the thread by marking correct and helpful responses.

Best,

Sunny