Forum Discussion

FarhanFahami_'s avatar
FarhanFahami_
Frequent Visitor
2 years ago
Solved

Power BI Progress Update Comparison between 2 dates

Greeting guys!   I'm currently stuck on building a visual matrix in PowerBI. My expected output should display the project details that show the progress based on the latest date compared to their ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

please provide sample data in a usable format, not as a screenshot.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You could theoretically use a measure for this, but it might be better to have a graphical solution, for example based on Visual Calculations.

     

    see attached.

    • FarhanFahami_'s avatar
      FarhanFahami_
      Frequent Visitor
      2 years ago

      Thank you for the attachment. However, my expected result is that it should only display Apartment and Condo as their latest 2 dates show the project progress (Apartment from Planning-31/12/23 to Building-31/1/24 and Condo from Building-31/12/23 to Selling-31/1/24).

       

      *My expected output should be like the first photo i shared in this post.