The good folks from SumProduct have published a challenge for Excel that I find worth doing in Power Query instead:
The Challenge
Stretching or compressing a forecast so that the proportion of the original series will be maintained:
The Function
This is not so easy mathematically (as the solution-blogpost explains in detail), so the code for the function isn’t short as well: