index month column to evaluate current year&month

[Anonymous]

Hi all,

How do you create a "index month column" that evaluates the current Year+month to be = 0

next month from now gets the value 1 and previous month from now is -1 

similarly 5 months ago gets the value -5

[amitchandak · Accepted solution]

@Anonymous , A new column if you have date

= datediff(eomonth([Date],0), eomonth(today(),0), month)

[Anonymous]

Thank you!  added a *-1  at the end to change to sign, so minus is in the past 🙂