Dax question

[Anonymous]

Hi guys, 

i Have a table with three columns

product, date and status 

for each product I want to know how many days this product remained in the same state until it has a new state. And I want to know at the end, how many days in the year the product remained in this same state and create a pie graph ? someone knows how to fix this issue ? 
for exemple the product A was on state "work" on 22/01/2023 and the 24/04/2023 and on that date it has already moved to another state who "disconnect" so I have to receive the result 2 for 2 days. 
i tried to use summarize but didn't work 

[Greg_Deckler]

@Anonymous Pretty sure you need Cthulhu. Cthulhu - Microsoft Power BI Community