How to populate current year and last/previous years' months booleans
Best Answer
-
in the formula for last year: yearvalue(Last Year?) line item. same for the current year put the formula as Yearvalue(current year?) .
If still facing any issues let me know.
1
Answers
-
If you are updating current period of model calendar, try
YEAR(CURRENTPERIODSTART()) = YEAR(ITEM(Time)).
1 -
Thanks! - on my case YEARVALUE() worked - sometimes you just get stuck on simple stuff 🙃
1 -
Hello , you can use the YEARVALUE() function to replicate year values across months
0