Forum Discussion
Let's explore how the Power Query List function helps to clean the data - Partial Search and Replace
In this video, we will learn how to use List.PositionOf function by writing our own comparer logic for data cleaning/transformation. We will match the partial value of a column and replace it with th...
Hi parry2k ,
Thank you for sharing. Please mark the answer to close the case and help more people to find the answer.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.