Calculate Difference Between Columns in Pivot Table

user0X · Jan 11, 2021

Is there a method/formula to calculate the difference between two columns generated from a single row for a pivot table?

alansidman · Jan 13, 2021

Pivot your data in Power Query and add a new column

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Description", type text}, {"Amt", Int64.Type}, {"Type", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Date"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Type]), "Type", "Amt", List.Sum),
    #"Added Custom" = Table.AddColumn(#"Pivoted Column", "Claim -CR", each [Claim]-[Cr])
in
    #"Added Custom"

Calculate Difference Between Columns in Pivot Table

user0X

New member

Attachments

alansidman

Member

Attachments