Karachi Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Creating A Custom Text Cleaning Function In Power Query

  • 1.  Creating A Custom Text Cleaning Function In Power Query

    Top Contributor
    Posted Mar 25, 2021 02:15 AM

    In this blog post, we'll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week.

    For week #2, we have a messy data that needs to be cleaned up. Our goal here is to clean up all the text values in both columns. You may watch the full video of this tutorial at the bottom of this blog.

    For this task, I created a clean text function.




    Ref: Creating A Custom Text Cleaning Function In Power Query
    Enterprise DNA remove preview
    Creating A Custom Text Cleaning Function In Power Query
    In this blog post, we'll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week. For week #2, we have a messy data that needs to be cleaned up.
    View this on Enterprise DNA >


    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------