Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
If I understand requirement correctly, try below
Table.SelectRows(#"Type changed", each not (Text.StartsWith([Field1], "607") and [Field2] = ""))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
If I understand requirement correctly, try below
Table.SelectRows(#"Type changed", each not (Text.StartsWith([Field1], "607") and [Field2] = ""))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.