how to operate a column with a parameter defined

[Anonymous]

Hi all,

I need your help.

I would like to subtract a value defined as a parameter in a collumn of a specific consult.

Better to understand with an example:

• PARAMETER DEFINED: 15  (decimal number)
• Current situation:

ROW    VALUE

Row 1     20

Row 2     40

• Result that I´m looking for:

ROW    VALUE    VALUE-PARAMETER

Row 1     20                  5

Row 2     40                  25

Thank you so much for your help!!!

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Do you mean like this? 

Here's the PBIX file

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjJQitWJVjIBUrEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Value", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each [Value] -Parameter1),
    #"Renamed Columns" = Table.RenameColumns(#"Added Custom",{{"Custom", "Value - Parameter"}})
in
    #"Renamed Columns"

 Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.