PQ - Risk rank

[sandy666]

Risk rank

Risk	Risk 2	Risk 3		Risk	Risk 2	Risk 3	Rank
Low	High	High		Low	High	High	High
High	High	Medium		High	High	Medium	High
Medium	High	Low		Medium	High	Low	High
Low	Medium	Medium		Low	Medium	Medium	Medium
High	Medium	Low		High	Medium	Low	Medium
Medium	Low	Low		Medium	Low	Low	Low

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Rank = Table.AddColumn(Source, "Rank", each if List.Count(List.Select(List.LastN(Record.FieldValues(_),2), each _ = "High")) >= 1 then "High" else if List.Count(List.Select(List.LastN(Record.FieldValues(_),2), each _ = "Medium")) >= 1 then "Medium" else "Low")
in
    Rank