title: How to get rolling 12 month sum in PowerBI
body: <p>I have to create sum of 12 month sales from last month of my date column.</p>
  
  <p>I have 3 years, 2016 to 2018 with Month and Year format and my dashboard is refreshed monthly adding next month.</p>
  
  <p>If the last date is oct 2018,</p>
  
  <p>I want to display 
  2018 as sum of sales from oct 18 - oct 17
  2017 as sum of sales from oct 17 to oct 16
  2016 as sum of sales from oct 16 to oct 15 and so on.</p>
  
  <p>Can you help how can i create the dax measure in power BI</p>
  
  <p>If I am using 
  = Calculate(sum(sales), dateadd(date, -12, month)
  It is displaying only year wise (calculating oct18 to jan 18 only) and not giving me the result as mentioned above.</p>
  
  <p>Can you help with the same?</p>