Difference between values of two previous dates in Power BI

Franc Ortz 21 Reputation points


I have a table that stores daily data related to the progress of projects. Therefore, a project has one row per day.
I'm interested in the difference of the %complete progress between the last two dates available in the table for each project name.

Similar to the table below, I need to present a matrix that contains the project name, the last 2 %complete values based on the last 2 dates, and the difference between those values.


Does someone know how to make this work?

This is an example of my original table:


I will appreciate your suggestions. :)

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,466 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.2K Reputation points MVP

    Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--

0 additional answers

Sort by: Most helpful