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

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!