title: How to calculate incremental values in Power BI using DAX query?
body: <p>I have a peculiar situation where I am trying to find the Incremental Values based on Cases/Deaths for country specific. Please see attached sample screenshot for reference on how my data looks.</p>
  <p>[![Sample Data][1]][1]</p>
  <p>I have 4 col - Day, Country , Cases/Deaths, Count. I have to calculate the increment of cases or deaths and then showcase the trend. My current file consists data at world level having all the countries with Days going for more than few months. I was able to perform the task in Excel with a small data as it was convenient to filter and then do the calculation.</p>
  <p>And one more point, For Day 0, as there are no count of cases or deaths from previous day, we are considering Day 0 count to be incremental value for showcasing trends.</p>
  <p>Can anyone guide on how to proceed with this task in Power BI?
  [1]: <a href="https://i.stack.imgur.com/4xNFV.png" rel="nofollow noreferrer">https://i.stack.imgur.com/4xNFV.png</a></p>