Forum Discussion
Create a comparaison report based on the same table
Hello, I have already ask some question. But i need your advice conserning a complex report. There is what I want to do : My problem is more complex because I have several column an...
Import the data table twice via power query.
In the first table, duplicate year column and minus one from the year (this is to use as a last year reference later).
Still in first table, merge the second table using a full outer join using the year-1 column, month, supplier and country.
Select cost data to merge and this will give you current year and last year cost side by side for exactly the same scenario, if there wasn't the scenario, either this year or last year, null will be returned.
Let us know how you go
In the first table, duplicate year column and minus one from the year (this is to use as a last year reference later).
Still in first table, merge the second table using a full outer join using the year-1 column, month, supplier and country.
Select cost data to merge and this will give you current year and last year cost side by side for exactly the same scenario, if there wasn't the scenario, either this year or last year, null will be returned.
Let us know how you go