Power BI Progress Update Comparison between 2 dates

[FarhanFahami_]

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 previous date.

For example, based on the below scenario, the output displays Project Condo and Apartment as their latest progress, which changed from Building (31-Dec-23) to Selling (31-Jan-24) for Condo and Planning (31-Dec-23) to Building (31-Jan-24) for Apartment. Bungalow is not displayed because the progress doesn't have any changes between the two latest dates (31-Jan-24 and 31-Dec-23, still in the Building phase).

Thanks in advance.

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[FarhanFahami_]

Awesome. Thank you!

[Ashish_Mathur]

You are welcome.

[lbendlin]

Use a measure as a visual filter to suppress rows where the value is the same.

[FarhanFahami_]

Based on the example, how should I use the measure to filter it by project and then compare its latest progress (based on the date) with the previous progress date?

[lbendlin]

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

[FarhanFahami_]

Sure! You can get the sample data from the link below(sorry this is my first time here, im not sure if there are any best method to share the data).

https://mega.nz/file/Zbl02QhK#To7eS0_KvgWVR7TKm2mVbbVI_Br0CizQeE9ny7RUCv4

[lbendlin]

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_]

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.

[lbendlin · Accepted solution]

[FarhanFahami_]

Awesome. Thank you so much!