number of months left in the model calendar

Options
CommunityMember124314
CommunityMember124314 Member, ALL USERS, Partner Posts: 1 New Contributor
in Planning & Modeling

Hi,

 

I'm looking for a way to reference the last month in the model calendar.

 

For Example My model Calendar is 1 previous year and 2 future years. Currently the last Period is June 2022 however when the model calendar increases i want the formula to reference the new end period.

 

I then want to count the months from the current period (item(time) to the End period (e.g. June 2022)

 

Ultimately my goal is to reference the number of months left in the time dimension.

 

 

Tagged:

Comments

  • Raul2104
    Raul2104 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Simple and useful. thanks Sai

     

    Regards

    Rahul

Categories