Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to clean rows based on a condition?

I am beginner and using Olist Store database. I am trying to clean the data by making a new column to clean errors where the delivered time is before the shipment or approved time. My plan was to mak...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Not sure, here are my steps, hope it helps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ31DcyMDJW0lEy0jeCMGN1ohEcHYSS2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"delivered date" = _t, #"shipped time" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"delivered date", type datetime}, {"shipped time", type datetime}}),
    Custom1 = Table.SelectRows(#"Changed Type",each [delivered date] >= [shipped time])
in
    Custom1

You can create a new blank query and paste the code into the advanced editor.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum