Difference between values of two previous dates in Power BI

Franc Ortz 21 Reputation points
2021-02-05T21:00:14.39+00:00

Hello,

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.

64752-image.png

Does someone know how to make this work?

This is an example of my original table:

64761-image.png

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
    2021-02-05T21:07:54.42+00:00

    Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

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


0 additional answers

Sort by: Most helpful