Forum Discussion

ToreVingare's avatar
ToreVingare
Frequent Visitor
6 years ago
Solved

Process mining gaps and islands

Hello!    I'm working on a process mining dashboard at my hospital. I have created all the timestamps that happens to our patient in the patientgroup but I can't succeed with the creation of a ID f...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    ToreVingare - OK, this was far easier than I thought it would be. But, it is a 2 step process:

    Consequective = 
    VAR __Previous = MAXX(FILTER('Table (3)',[Person]=EARLIER([Person]) && [End]<EARLIER([Start])),[End])
RETURN
    IF(ISBLANK(__Previous) || ([Start] - __Previous)*1. < .000695,1,0)


Group = COUNTROWS(FILTER('Table (3)',[Person]=EARLIER([Person]) && [Start] <= EARLIER([Start]) && [Consequective]=0))+1

    Those are columns. Attached a PBIX file below sig. Table (3). 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

ToreVingare - OK, this was far easier than I thought it would be. But, it is a 2 step process:

Consequective = 
    VAR __Previous = MAXX(FILTER('Table (3)',[Person]=EARLIER([Person]) && [End]<EARLIER([Start])),[End])
RETURN
    IF(ISBLANK(__Previous) || ([Start] - __Previous)*1. < .000695,1,0)


Group = COUNTROWS(FILTER('Table (3)',[Person]=EARLIER([Person]) && [Start] <= EARLIER([Start]) && [Consequective]=0))+1

Those are columns. Attached a PBIX file below sig. Table (3). 

  • ToreVingare's avatar
    ToreVingare
    Frequent Visitor
    6 years ago

    Wow! It works great! You saved my weekend! 🙏

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Greg_Deckler,

     

    Is there a way we achieve same in PowerQuery? If yes, can you update the same PBIX. I'm struggling to achieve it.

     

    Thank you so much in advance.