Count days without change in a string per order

[Inventrius]

Hi,

I'm quiet new to PowerBi and trying to get a hand of PowerQuery. 

For a dashboard I'd like to make I want to monitor the amount of days that there is no change in a certain value. 

The data looks as following:

I want to create an extra column that indicates the amount of days without change in the string of the Qcode column.

So when using a table PowerBi that I can see per specific order how long there has/hasn't been any change to the Qcode string.

In this case the 8th of September should show 8, but with the 11th it should be 0 again as the string has changed.

Initially I was thinking to make an additional column, stating 1 or 0 if the previous day is the same and then simply sum it in the table. But this will not turn it into zero if there are changes to the string.

No clue where to begin here, but hopefully someone can point me in the right direction. 

Cheers,

Inventrius

[Greg_Deckler]

@Inventrius Can you post the sample data as text? If DAX is an acceptable solution, you could try Cthulu: Cthulhu - Microsoft Fabric Community