Forum Discussion
Evolution years power query
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 ?
1 Reply
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-p/963216
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
