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 grou...
Need Help
CNENFRNL's avatar
CNENFRNL
Community Champion
3 years ago

Easy enough, simply group the dataset in PQ.

pratafran's avatar
pratafran
Helper III
3 years ago

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