title: power bi year over year comparison and line chart
body: <p>I want a custom table/matrix in power bi displaying the year over year data and also a line chart displaying the same. i have all the year information in one column i.e both 2018 and 2019 data in one column. I want to perform an aggregate operation on another column and make the comparison for each of the month in the previous year </p>
  
  <p><a href="https://i.stack.imgur.com/jHfiY.png" rel="nofollow noreferrer">The checkout date column has all the date information for both years. The caring attitude column has the data for which i want to perform aggregation based on month</a></p>
  
  <p><a href="https://i.stack.imgur.com/b5sqh.png" rel="nofollow noreferrer">This is how i want the data to be displayed in the power bi</a></p>
  
  <p><a href="https://i.stack.imgur.com/Vac1D.png" rel="nofollow noreferrer">This is the line chart i want. Year over Year comparison of those values</a></p>
  
  <p><a href="https://i.stack.imgur.com/iFx9X.png" rel="nofollow noreferrer">In Excel I manually add the goal values in the rows and then create a graph</a></p>