Skip to main content
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

Helper IV
Helper IV

Help with Tracking Status Changes


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. 

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     
Ready for PIEITEAM-10     
PI Committed EITEAM-10EITEAM-10EITEAM-10  
In Progress    EITEAM-10EITEAM-10
Ready for PI EITEAM-11    
In Progress     EITEAM-11
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


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?


Helpful resources


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.


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.