Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Formula Examples: Dynamic Time Reference

Describes a workaround for referencing the same month across multiple years.

To reference a particular month in the current year, you cannot use syntax like this in a formula:

 [time=month_number/this.year]

But, you can use an IF or IFF  statement to accomplish similar results. For example, to reference the month of January (month = 1) in a series of successive years, use the following:

IFF(year(this)=2017,ACCT.IT_Expense[time=01/2017],IFF(year(this)=2018,ACCT.IT_Expense[time=01/2018],IFF(Year(this)=2019,ACCT.IT_Expense[time=01/2019]...