Calculate change % week on week duration

[soumyaiyer]

Hello,

Need help to calculate week on week % change with duration as value in power query.

Below the matix table with the week number and total duration for each week . 

Any help is greatly appreciated! Thanks!

[speedramps]

Click here to donwload the solution form Onedrive

Click here 

Please click thumbs up for me trying to help, because it took a lot of effort.

Then click accept solution if it works. Thank you !

How it works ...

The AHT Time has a time data type.
I recommend you convert it to seconds

= (Duration.Hours([AHT Time] - #time(0,0,0)) * 60 * 60) +
(Duration.Minutes([AHT Time] - #time(0,0,0)) * 60) +
Duration.Seconds([AHT Time] - #time(0,0,0))

The get the previous row  value

try #"Get AHT seconds" [AHT seconds] { [Week] - 2 } otherwise null

The get the difference

Calculate the persentage

And change the data type to percentage

Please click thumbs up for me trying to help, because it took a lot of effort.

Then click accept solution if it works. Thank you !