Forum Discussion
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
- CNENFRNLCommunity Champion
Easy enough, simply group the dataset in PQ.
- pratafranHelper 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
- pratafranHelper III
Any clue on this?