Power Query Merge Columns with Conditions

[jalejandro0211]

[FONT=&quot]Hi, I have the following situation in PowerQuery:<o></o>[/FONT]
[FONT=&quot]I have a table something like this:<o></o>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Vendor | Product | BalanceM1 | BalanceM2 | BalanceM3 | BalanceMn<o></o>[/FONT]
[FONT=&quot]Pepe | Sprite | Sprint10 | Sprint 11<o></o>[/FONT]
[FONT=&quot]Jhon | Coke | Sprint 9<o></o>[/FONT]
[FONT=&quot]Lud | Beer | Sprint 12 | Sprint 13 | Sprint14<o></o>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]So I need a filtered table only with the most recent sprint forex:<o></o>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Vendor | Product | MostSprintRecent<o></o>[/FONT]
[FONT=&quot]Pepe | Sprite | Sprint 11<o></o>[/FONT]
[FONT=&quot]Jhon | Coke | Sprint 9<o></o>[/FONT]
[FONT=&quot]Lud | Beer | Sprint14<o></o>[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Can you help me?<o></o>[/FONT]

 

[jalejandro0211]

Ready

let
Source = Excel.CurrentWorkbook(){[Name="Tabla1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Columna1", type text}, {"Columna2", type text}, {"Columna3", type text}, {"Columna4", type text}, {"Columna5", type text}, {"Columna6", type text}}),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type", {{"Columna1", type text}, {"Columna2", type text}, {"Columna3", type text}, {"Columna4", type text}, {"Columna5", type text}, {"Columna6", type text}}, "en-GB"),{"Columna1", "Columna2", "Columna3", "Columna4", "Columna5", "Columna6"}, each _,"MergedBalances"),
#"Lowercased Text" = Table.TransformColumns(#"Merged Columns",{{"MergedBalances", each List.Last(List.Select(_, each _<>null))}})
in
#"Lowercased Text"