Forum Discussion
Year comparison
Hi all, I want to compare previous year with current year. In that comparison i want to assign all the starting date of the all the months of previous year as "X" and the rest is "Y" and endin...
Hi Anonymous ,
Did you have a CALENDAR table? How about changing the formula as below?
List =
SWITCH(INT('Table'[Year]),
2018, if('Table'[day]=STARTOFMONTH('CALENDAR'[date]),"X","Y"),
2019, if('Table'[day]=ENDOFMONTH('CALENDAR'[date]),"X","Y")
)
I have used calender table