Add Custom Row (Table.InsertRow)

Hi

Is it possible to add a row based on certain conditions?

The logic for my query is:

Current table

Product number    Province

A001                       Ontario

A001                      Alberta

B001                       Quebec

B001                      Alberta

For each product number in the table IF (Province) <> "Yukon Territory" then INSERT row "Product number and Province = "Yukon Territory"

IF (Province) <> "Quebec" then INSERT row "Product number and Province = "Quebec"

Desired output 

Product number    Province

A001                       Ontario

A001                      Alberta

A001                      Yukon Territory

A001                      Quebec

B001                       Quebec

B001                      Alberta

B001                      Yukon Territory

Works great! Thanks

You absolute beast ! So simple

Thanks !

Hi stretcharm

Can you help me out here, I am trying to SUM the values of all column in to NET INCOME row. I used the following code, but its giving me error values. 
PFA screenshot of the data and code.

Thanks in advance.

Regards,

Sahil

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIE4sjUYqVYnWglIyDbCcaPBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"scode"= _t, #"sdesc" = _t, #"MyYTDComparative" = _t, #"MyYTDVariance" = _t, #"MyYTDBaseline" = _t, #"MyYTDVariancePercentage" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"MyYTDComparative", Float64.type}, {"MyYTDVariance", Float64.type}, {"MyYTDBaseline", Float64.type}, {"MyYTDVariancePercentage", Float64.type}}),
Custom1 = Table.InsertRows(#"Changed Type",2, { [scode = 829999, sdesc = "NET INCOME" ,MyYTDComparative = SUM(MyYTDComparative), MyYTDVariance = SUM(MyYTDVariance), MyYTDBaseline = SUM(MyYTDBaseline), MyYTDVariancePercentage = AVERAGE(MyYTDVariancePercentage)] })
in
Custom1