In Power Query I'm trying to filter out and total rows from a data set. Total rows are designated as "Total ..." in [Column1]. So I used the drop down "Text Filter > Does Not Begin With..." which places a "not Text.StartsWith([Column1], "Total") in the code. The problem is this not only filter out where [Column1] starts with "Total" but also filters out null values. This doesn't at all make sense as a null value does not begin with "Total". Does anyone have any insight into this issue and have a solution other than replacing null w/ "zzzzzzzzzz" then filtering not starts with "Total" then replacing "zzzzzzzzzz" with null.