Evolution years power query

[tororo]

Hello everyone,

I Want to follow the evolution of people's remuneration over several years in Power Query. I have a table linked to other tables that looks like this :


Fom this table I would like to get something like that with the years in columns :

Country Name Position   Year     Evolution % N-1 Year   Evolution % N-2 Year Evolution %
Finland  Toto    President  2022  35 %            2021           - 26 %            2020 43 %
USA       Bubu   CEO         2021   45 %           2020

I want to calculate tehe evolution of the salary (in OTC and in Paid loc compared to the previous year) and after in power bi desktop on my visual table I want a selector to display my evolution table either in OTC or in Paid. I want to calculate the table evolution IN POWER QUERY. Small specificity the salaries of future years like 2023 will be added in the future and it would be necessary that the treatment in power query makes it possible to calculate the evolution for these futur years (for example the evolutin of OTC in 2023 compared to 2022) Can you help me to do this in Power Query ?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523