Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help with custom column displaying a values if the conditions are met.

Hello!   I have some rates on a table.  Column [RATE] which only has two different value choices (RateA and RateB) and column [FUEL] which has currency value of the fuel cost. I want the custom col...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Anonymous ;

    You can add a conditional column  in power query such as:

    The final show:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkosSXVU0lGyUIrVQfAsUXiGBnCuE5BrZIbCNTRWio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [RATE = _t, FUEL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"RATE", type text}, {"FUEL", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [RATE] = "RateA" then [FUEL] else null)
in
    #"Added Conditional Column"


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous ;

You can add a conditional column  in power query such as:

The final show:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkosSXVU0lGyUIrVQfAsUXiGBnCuE5BrZIbCNTRWio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [RATE = _t, FUEL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"RATE", type text}, {"FUEL", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [RATE] = "RateA" then [FUEL] else null)
in
    #"Added Conditional Column"


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.