Add a row based on conditions

[Jacob1832]

My data set has a state column. I just want to add a row in my data set if the state column doesnt contain 'TX' in one of its rows. I dont care the method. 
If it was possible to add it straight to the visual with the conditions rather than the data, that would be cool too but i dont think its possible.

[Anonymous · Accepted solution]

Hi @Jacob1832 ,

Try to use the Table.InsertRows in the Power Query Editor.

In the advanced editor, like below.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTI0MFCK1YlWSgKyjaDsZCDbGMSOBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [state = _t, value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"state", type text}, {"value", Int64.Type}}),
    Custom1 = Table.InsertRows(#"Changed Type",2, { [state = "d", value = 400] })
in
    Custom1

Table.InsertRows - PowerQuery M | Microsoft Docs

How can I manually add a row to an existing table in Power Query? ~ Hey Niels!

Best Regards,

Stephen Tao

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

[lbendlin]

Power BI cannot add rows.  You need to do that either in Power Query or in the upstream system.