Forum Discussion
current and previous year flag issues
Hi Team, I am trying to filter current year and previous year as i have created the calucalted column when i filter the flag as 1 it will filtering the only current year but not filtering the previou...
Tahreem24 both are giving same results it will not filter out the previous year and filtering the current year only. I need formula to filter current and previous year as well.
Tahreem24
Super User
Super UserAnonymous , Tweak your formula like this:
Current Year = IF (
YEAR ( Table1[Acquired Date] ) = YEAR ( TODAY ()-1 )&&YEAR(Table1[Acquired Year]=YEAR(TODAY())),
1,
0
)
Tahreem24 both are giving same results it will not filter out the previous year and filtering the current year only. I need formula to filter current and previous year as well.