{"id":74,"date":"2026-02-25T08:41:57","date_gmt":"2026-02-25T08:41:57","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&p=74"},"modified":"2026-03-14T08:13:38","modified_gmt":"2026-03-14T08:13:38","slug":"cleaning-data-remove-duplicates-trim-replace","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/cleaning-data-remove-duplicates-trim-replace\/","title":{"rendered":"Cleaning Data (Remove Duplicates, Trim, Replace)"},"content":{"rendered":"\n

<\/p>\n\n\n\n

Cleaning data is one of the most important steps in Power BI to ensure accurate analysis. Power Query provides simple tools to clean and prepare your data before creating reports and dashboards. Common cleaning tasks include removing duplicates, trimming extra spaces, and replacing values.<\/p>\n\n\n\n

Remove Duplicates<\/strong><\/h2>\n\n\n\n

Duplicate records can affect the accuracy of your analysis. Power Query makes it easy to remove them:<\/p>\n\n\n\n

    \n
  1. Open Power Query Editor in Power BI Desktop.<\/li>\n\n\n\n
  2. Select the column(s) you want to check for duplicates.<\/li>\n\n\n\n
  3. Go to the Home tab<\/strong> in the Ribbon and click Remove Rows > Remove Duplicates<\/strong>.<\/li>\n\n\n\n
  4. Power Query will keep the first occurrence and remove all duplicate entries.<\/li>\n<\/ol>\n\n\n\n

    Trim Data<\/strong><\/h2>\n\n\n\n

    Extra spaces in your data, especially in text fields, can cause errors in analysis or mismatched records. To trim spaces:<\/p>\n\n\n\n

      \n
    1. Select the column you want to clean.<\/li>\n\n\n\n
    2. Go to the Transform tab<\/strong> in the Ribbon.<\/li>\n\n\n\n
    3. Click Format > Trim<\/strong>.<\/li>\n\n\n\n
    4. This removes any leading or trailing spaces from the selected column.<\/li>\n<\/ol>\n\n\n\n

      Replace Values<\/strong><\/h2>\n\n\n\n

      Sometimes data contains incorrect or inconsistent values that need to be standardized. Power Query allows you to replace values easily:<\/p>\n\n\n\n

        \n
      1. Select the column where you want to replace values.<\/li>\n\n\n\n
      2. Go to the Transform tab<\/strong> in the Ribbon.<\/li>\n\n\n\n
      3. Click Replace Values<\/strong>.<\/li>\n\n\n\n
      4. Enter the value to find and the value to replace it with, then click OK<\/strong>.<\/li>\n\n\n\n
      5. Power Query will update all occurrences of the value in the selected column.<\/li>\n<\/ol>\n\n\n\n

        Additional Tips<\/strong><\/h2>\n\n\n\n