Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I am trying to clean a column
in the above screenshot. e.g. Furniture, Mattresses, Other, Pallets, Gardenwaste is a category which i want to seperate in another column. Also there is a description in some rows like "full bottles of fizzy..." and other rows above it.
i want it to be blank as it does not belong to any category.
Can i use LIKE function in M query
Cheers,
Solved! Go to Solution.
@chavanr , See if Text.Contains can help
https://docs.microsoft.com/en-us/powerquery-m/text-contains
@chavanr , See if Text.Contains can help
https://docs.microsoft.com/en-us/powerquery-m/text-contains
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |