Forum Discussion
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 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.
11 Replies
- lbendlin
Super User
Use a measure as a visual filter to suppress rows where the value is the same.
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.
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.
Awesome. Thank you!
- Ashish_Mathur
You are welcome.
