https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-question/m-p/3049009#M104940 <P>Anonymous</LI-USER>&nbsp;Pretty sure you need Cthulhu.&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739#M211" target="_blank">Cthulhu - Microsoft Power BI Community</A></P> Sun, 29 Jan 2023 16:21:21 GMT Greg_Deckler 2023-01-29T16:21:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-question/m-p/3048970#M104936 <P>Hi guys,&nbsp;</P><P>i Have a table with three columns</P><P>product, date and status&nbsp;</P><P>&nbsp;</P><P>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 ?&nbsp;<BR />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.&nbsp;<BR />i tried to use summarize but didn't work&nbsp;</P> Sun, 29 Jan 2023 15:16:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-question/m-p/3048970#M104936 Anonymous 2023-01-29T15:16:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-question/m-p/3049009#M104940 <P>Anonymous</LI-USER>&nbsp;Pretty sure you need Cthulhu.&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739#M211" target="_blank">Cthulhu - Microsoft Power BI Community</A></P> Sun, 29 Jan 2023 16:21:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-question/m-p/3049009#M104940 Greg_Deckler 2023-01-29T16:21:21Z