Fiscal year sum to columns

[Gohard]

Hello,
I am trying to create a query where data regarding fiscal years for the same customer will be visible in columns rather than rows. Here is example of kind of data I have:

Country	Customer	Fiscal year	Sales
Austria	123456	2018	5980
Austria	123456	2019	598
Germany	98745	2018	52222
Spain	6545	2018	486
UK	2561	2018	4
Austria	58452	2018	8321
Austria	54	2019	2
Germany	948	2019	31

And to be able to make Year over year calculation I would like to see this data in columns (example below):

Country	Customer	2018	2019	YoY
Austria	123456	5980	598	2019/2018
Austria	123456	2	12	2019/2018
Germany	98745			2019/2018

Is it possible to do it within the query? I am just starting and am still struggling a bit. Example also attached.
View attachment example.xlsx

 

[horseyride]

Highlight your table. Data..from Table/Range ... with [x] my table has headers. In powerquery click on the fiscal year column and do transform....pivot... For value column pick sales. Not sure the point of the final column YOY. If you want the delta, then click on both the 2018 and 2019 columns and right click replace and then replace null with 0. Then Add Column..Custom column... and use formula [2019]-[2018] and click ok

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Country", type text}, {"Customer", Int64.Type}, {"Fiscal year", Int64.Type}, {"Sales", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Fiscal year", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Fiscal year", type text}}, "en-US")[#"Fiscal year"]), "Fiscal year", "Sales", List.Sum),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"2018", "2019"}),
    #"Added Custom" = Table.AddColumn(#"Replaced Value", "YOY", each [2019]-[2018])
in
    #"Added Custom"