Dynamic Time Reference Example
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]...