How to Compare This Year vs Last Year in Tableau (Even If This Year Isn’t Complete)

Learn how to compare this year vs last year in Tableau with a dual-axis line chart — even if the current year has incomplete data. This step-by-step tutorial shows you how to create a year-over-year comparison by aligning this year and last year by month on the same timeline. You’ll learn to: • Create separate lines for this year and last year • Align them by month even if this year doesn’t have full data • Use dual-axis formatting to overlay the lines Tableau: https://public.tableau.com/app/profil... Tableau Video Index: https://sites.google.com/view/tableau... Excel: https://docs.google.com/spreadsheets/... Formulas: This Year: IF YEAR([Date]) = YEAR(TODAY()) THEN [Revenue] END Prior Year: IF YEAR([Date]) = YEAR(TODAY()) - 1 THEN [Revenue] END