Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bcobrien1977
Helper IV
Helper IV

Help with Tracking Status Changes

Hi,

I am trying to track staus changes over time for a list of projects and indicate for a month how many projects started and here is how they landed at a month end.  Here is a snapshot of the data where I want to look at the date fields to show where something was at a particular date and the string fields to show the status. 

IssueKeySummaryOldStringNewStringStartDateEndDate
EITEAM-10StabilityReady for PIPI Committed7/29/20228/31/2022
EITEAM-10StabilityPI CommittedIn Progress8/31/202211/30/2022
      
EITEAM-11ChangeReady for PIPI Committed8/15/20228/31/2022
EITEAM-11ChangePI CommittedDone8/31/202212/10/2022

 

For the output I basically need to bucket each project and then I would probably assign numerical values to each status to take the difference between the starting stage (Ready for PI) and the last reported stage .  I can't seem to get the measure to work correctly.

Can anyone provide some guidance?  Thanks

 

 Desired Output     
       
 31-Jul31-Aug30-Sep31-Oct30-Nov31-Dec
       
Ready for PIEITEAM-10     
PI Committed EITEAM-10EITEAM-10EITEAM-10  
In Progress    EITEAM-10EITEAM-10
Done      
       
       
 31-Jul31-Aug30-Sep31-Oct30-Nov31-Dec
       
Ready for PI EITEAM-11    
PI Committed EITEAM-11EITEAM-11EITEAM-11EITEAM-11 
In Progress     EITEAM-11
Done      
2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @bcobrien1977 

 

Is it possible that some status can be skipped? In your example of EITEAM-11, the status after "PI Committed" is "Done", it doesn't have "In Progress" row. Is this a correct result? Is this possible to happen on other issues? 

 

In addition, for "EITEAM-10", does it have a row with an old string "In Progress"? In your example, it seems "In Progress" is the last and current status for "EITEAM-10". I wonder if every issue has a row for its last status? 

 

I intend to make every issue have a row for every status it experiences and each status row have a start date and end date. 

 

Best Regards,
Community Support Team _ Jing

Hi,

That is part of the problem that you can move through more than one status.  So basically you could move from two spots simultaneously. I know this is not totally logical but basically it has to do with delays in stafff entering the data. 

 

Yes, you are right on the E-Team 10.  


Another way to think about it is.....

 

If you had 100 projects at the start of the quarter, how many ended up at each stage?

Thanks

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.