Obtaining the Maximum value from a table field and parsing same as a parameter to that column for subtraction by all records of the same column

Question

I need to fetch the Maximum value from a table column and parse same (i.e. this maximum value as a parameter) to the same column for subtraction in an added (new) column (called difference):

Example:

    Month_number 
    5
    6
    7
    8
    9
    5 
    5
    6

I need to take the Maximum value "9" of the month_number field and use this(9) a parameter to subtract each record of the same column to then get a new column called "difference" like this:

It would help if you had an example and a specific question. — Alexis Olson
I'm really sorry. I have provided an example to better explain the question. Thanks. — ju'blu'

Storax Storax · Accepted Answer · 2020-12-12T12:28:34

Just add a step where you determine the minimum for example

let
    Source = Excel.CurrentWorkbook(){[Name="tblInp"]}[Content],
    min = List.Min(Source[Nr]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Nr", Int64.Type}}),
    Diff = Table.AddColumn(#"Changed Type", "Diff", each [Nr]-min)
in
    Diff

Obtaining the Maximum value from a table field and parsing same as a parameter to that column for subtraction by all records of the same column

1 Answers