Forum Discussion
Calculating date/hour difference from separate rows
Hi all, I am having a messy problem with calculating time difference (DD,HH,MM) of separate rows. I have dataset of tasks, containing ALL the revision history. So basically, all the steps, modi...
Hi jereaallikko
I guess I understand your requirement but still hope to confirm some points first.
1. For a task with multiple pairs like 43212, a pair should be a info request event and the first info responded event happened after it, right?
2. Do you need other non-pair rows for other use in the report? Can we filter out them to reduce the rows in the model or you want to keep them?
3. You hope to deal with this with DAX method or also welcome some M in Power Query Editor with some data transformation?
Regards,
Community Support Team _ Jing