Custom column with condition from other column

[Anonymous]

= Table.AddColumn(#"Replaced Value", "NewColumn", each if [ID] = "A12153" then [Type] ="Hard" else [Type])

The result for ID displays FALSE.

-- i am looking similar to below in power bi.

update table set Type = "Hard"  where ID = "A12153"

Need help. Thanks for looking

[Anonymous · Accepted solution]

Hi @Anonymous 

I think you want to change the values in Type column to "Hard" if the ID = A12153, and other ID will keep the values in Type column.

I build a sample table to have a test.

You can try Conditional column in Add column.

Remove Type column and rename the new column, result is as below.

Or you can copy my M Query and paste it into Advanced Editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcjQ0MjQ1VtJRclSK1YFyTYBcJwTXHMh1RnBBioMRXDMg1wVV1lUpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Type = _t]),
    #"Added Conditional Column" = Table.AddColumn(Source, "Custom", each if [ID] = "A12153" then "Hard" else [Type]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Conditional Column",{"Type"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Type"}})
in
    #"Renamed Columns"

 You can download the pbix file from this link: Custom column with condition from other column

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , The part should be like

if [ID] = "A12153" then"Hard" else [Type]

[Sumanth_23]

hi @Anonymous - Let me know if this the desired output you are looking to achieve. 

Status = IF ('ID-Data'[ID] = "A12153", "Hard")

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!