Forum Discussion
Power BI Progress Update Comparison between 2 dates
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?
please provide sample data in a usable format, not as a screenshot.
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
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.
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.