Difference between dates in the same column based on the value in the other column

[mikah]

Hi All,

I have a problem in Power BI getting the difference between dates in the same column based on the value in the other column.

Here is the scenario:

I wanted a result:

- the average time of pending_transmit to posted

- the average time of pending_delete to expired

OUTPUT to table

Table for pending_transmit to posted

Table for pending_delete to expired

Your help is very much appreciated.

Thank you!

[Syk]

Can you share a bit more of your starting data table? I have a feeling using a pivot in power query will solve this for you.

[mikah]

This is my data table