Remove empty Tip on Power Query

[HakamAbushanab]

When cleaning up your datasets in #PowerQuery, the default option "Remove empty" is often used to eliminate blank rows. However, there's a caveat to be aware of: not all "blanks" are truly empty. Some may just be spaces which the default option won't catch.

To ensure a comprehensive cleanup, modify your M code as follows:

**Original Code:**
```m
= Table.SelectRows(#"Removed Columns2", each [Sales Doc.] <> null and [Sales Doc.] <> "")
```

**Improved Code:**
```m
= Table.SelectRows(#"Removed Columns2", each [Sales Doc.] <> null and [Sales Doc.] <> "" and [Sales Doc.] <> " ")
```

This enhancement ensures that rows with spaces posing as "blanks" are also removed, leading to a cleaner dataset.

---

Hope this helps, and happy data cleaning! 🙂
.
.
.
.
.
.
#powerbi #dataanalytics #dataanalyst

[mlsx4]

Hi @HakamAbushanab 

There is also a good option which is TRIM everything to avoid unnecessary characters 😉 : https://radacad.com/trim-vs-clean-in-power-bi-and-power-query

[HakamAbushanab]

Hello Rada,

Upon reviewing your website, I noted that the trim function is an effective solution for eliminating superfluous characters, as you mentioned. It appears that your dataset contains some unnecessary characters on certain rows. Conversely, in my dataset, I observed purely blank rows. By employing the default 'delete nulls' option in Power BI, I was able to remove a majority of the nulls present in the files. However, some of the rows that seemed to be nulls were actually spaces, which led me to enhance the code with an additional condition to eliminate spaces: [Sales Doc.] <> " "      : )