How to Remove Changing Values

Hi Belgarion42 

Download PBIX file with the example below

This code will do the job

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcszLK03MUXDOz83NLMlNzStR0DAw0jcw1DcyUdBVANLGQKapppKOkpmZgYFSrE60UnhqaraCsYlCSGJRemqJgl9pblJqEVCBiaGFEYoCx+QSkNkIBSYWEBOAthXkpJZk5ucpBKQWJQNtTUxPBVoH1QhUaqBnZm4BhpZKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Annual Commit" = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Annual Commit", type text}, {"Column2", type number}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each let _words = Text.Split([Annual Commit], " ") in

if Text.Contains([Annual Commit], "Annual") then _words{0} & " " & _words{1} 

else if Text.Contains([Annual Commit], "Target") then _words{2} & " " & _words{3} 

else if Text.Contains([Annual Commit], "Actual") then _words{2} & " " & _words{3} 

else if Text.Contains([Annual Commit], "Completion") then _words{0} & " " & _words{1} 

else [Annual Commit]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Annual Commit"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Annual Commit"}}),
    #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns",{"Annual Commit", "Column2"})
in
    #"Reordered Columns"

Before:

After:

Regards

Phil