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 colum to display the value of [FUEL] if the value of [RATE] is RateA ortherwise just be null.

 

thanks for your time.

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.

2 Replies

  • 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.

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi Anonymous ,

     

    Do we only have the rate and cost? What is the logic to assessing whether it is Rate A or B?

     

    Regards

    KT