Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

how to operate a column with a parameter defined

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!!!

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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.

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    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.