Multiple dates in Multiple rows and columns with repeating IDs

[Shashi_Kant82]

Hi All,

I am having multiple dates in my table but they are on separate rows see below table.

I want to calculate how many percent orders are in order date  to approved stage, approved stage to ship stage and ship stage-delivered stage. also want to calculate the days difference between each stage. is there any way i can bring it in a single row? or any calculation which can be applied to get the output like below:-

Nos. in the screenshot are just for demo, TIA

[Shashi_Kant82]

@amitchandak Tried, But not working in this case

[amitchandak]

@Shashi_Kant82 , You can use group by in power query to bring them in one row

https://docs.microsoft.com/en-us/power-query/group-by