title: This Year vs Last Year Calculation
body: <p>I am working on a line chart with 3 curves: results, quota, and previous year where year and metric are selected with slicers.</p>
  <p>My table which is prepared before into Power query looks like below however, I have problems inserting the previous year's curve.</p>
  <p>What is the best way to do this?</p>
  <p><a href="https://i.stack.imgur.com/Np3fF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Np3fF.png" alt="enter image description here" /></a></p>
  <p>For example, if the slicer is settled with 2021, the slice table should show values Quota (2021) and Results (2021), and Results (2020) for comparison. The column Category is set in Legend.</p>
  <p><a href="https://i.stack.imgur.com/1KRaM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1KRaM.png" alt="enter image description here" /></a></p>
  <p>Chart with missed Last Year values
  <a href="https://i.stack.imgur.com/Y6YSD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y6YSD.png" alt="enter image description here" /></a></p>