Power Query: not Text.StartsWith removes blank/null values

[ko1967]

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.

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Result = Table.SelectRows(Source, each (Text.Start(Text.From([Month]), 5) <> "Total"))
in
    Result

Book2
	A	B	C	D	E	F
1	Month	Value		Month	Value
2	1	12		1	12
3	1	9		1	9
4	1	16		1	16
5	1	5		1	5
6	Total for Month 1	42
7				2	1
8	2	1		2	8
9	2	8		2	17
10	2	17
11	Total for Month 2	26		3	3
12				3	14
13	3	3		3	13
14	3	14		3	2
15	3	13		3	15
16	3	2		3	7
17	3	15
18	3	7
19	Total for Month 3	54
20
Sheet2

Cell Formulas
Range	Formula
B6	B6	=SUM(B2:B5)
B11	B11	=SUM(B8:B10)
B19	B19	=SUM(B13:B18)