Latest status change and days left/passed to the target date

[jojo]

Hi All,

I want to solve latest the status change date? and the remaining time between the latest status and due(target)date? and period/duration from the latest change and previous statuses?

Attached is the PBI and spread sample data.

Project Progress Status Sample Data.xlsx (14.0 KB)
Project Progress Status Sample.pbix (96.9 KB)

Thank you,

[ankit]

Hi @jojo - In the sample provided column “Project Status Change Date” is not properly maintained. For example, for Title 1 “Status Change Date” is populated for Row 1 i.e. “New” Status while for “Title 4” it is blank for “new” status and has value for final status.

Please share the reason behind this.

Thanks
Ankit J

[jojo]

Hi @ankit - Yeah that was actually a typo mistake. If status is ‘New’, there shouldn’t be a progress status change date. I’ve uploaded a corrected spread sheet. Thank you!
Project Progress Status Sample Data.xlsx (14.0 KB)

[ankit]

Hi @jojo - This seems repeat of question Project Progress Status Report. Has that resolved your queries or some are still pending.

If pending, provide what is needed.

[jojo]

Hi @ankit Yes this is resolved in another thread. Thanks.

[jojo]

Hi @ankit , Is there any particular power bi default or custom visual to show multiple dates on time line. what I find in power bi is only taking two date inputs (start and end dates). I want to produce chart similar to the image below.

thanks

[Jonah]

Please @jojo can you kindly share the link to the thread your question was resolved? or please kindly share the DAX code here. I have a similar challenge.
Many thanks,
Jonah

[jojo]

Hi @Jonah,

Here is the link to the original post with the suggested solution.

Project Progress Status Report

Hello everyone, I have this Project status data which shows the status of the different projects, the resources available, the different status changes, and stages the process pass through. What I am looking for: 1.What set metrics I may show for some who wants to understand the status/progress of the project? May be show me some ideas or a couple of sample charts that can provide an insight. 2.Calculate the status changes, probably to show the latest status? or to show the Status change in …

Thank you,
Jojo

[Jonah]

Hi @JarrettM,

Please any solution to this below?
Lets say I have a set target of HIV test of 1000 from Oct 2021 to September 2022. As at June 2022 we have achieved 700 (70%) remaining 300 (30%) to be achieved in Jul/Aug/Sept (i.e Q4). How can I calculate the following and have it show up on timeline bar on my dashboard.

1. 300 to be recalibrated across the 3 months to show daily (300/no of remaining days),
   weekly(300/no of remaining week) and monthly target (300/no of remaining Month).
2. Display the number of remaining days, week, months to end the FY

[Keith]

@Jonah
start a new topic…already solved

hoover over the blue circle bottom right hand corner on the main screen. it will turn into +New topic

thanks

[Jonah]

HI @Keith
Many thanks for your effort.
I will as guided.
Thanks,
Jonah