Calculate change % week on week duration

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 !