DAX for Grouping table based on atributes and sequential datetime

[pratafran]

Hello comunity,

I have a calculated table which have details by minute (date + hour + minute) of a machine which is producing or stopped due to X cause.

Now I need to show the data groupped by periods of time depending on the Machine/Status/Interruption cause.

I tried to create a matrix and set two columns with the DateTime, one as Earliest and other with Latest but I does not get the result expected since in the above example, I get the minimun and maximun Time for the Working status but without keeping the sequence.

I expect to get the following result

I think that making an index it could make the group as expected but since it is a calculated table I cannot use PowerQuery and have to rely in DAX where I dont know how to proceed.

Any ideas?

Thanks!

[pratafran]

Any clue on this?

[CNENFRNL]

Easy enough, simply group the dataset in PQ.

[pratafran]

It is not possible to use PQ since it is a calculated table generated with DAX.

On the other hand, even grouping with SUMMARIZE, I do not get the expected result since it does not take into account the sequence getting This:

instead of this