Forum Discussion

pratafran's avatar
pratafran
Helper III
3 years ago

DAX for Grouping table based on atributes and sequential datetime

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!

3 Replies

    • pratafran's avatar
      pratafran
      Helper III

      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