PQ - Risk rank

[sandy666]

Risk rank


RiskRisk 2Risk 3RiskRisk 2Risk 3Rank

LowHighHighLowHighHighHigh

HighHighMediumHighHighMediumHigh

MediumHighLowMediumHighLowHigh

LowMediumMediumLowMediumMediumMedium

HighMediumLowHighMediumLowMedium

MediumLowLowMediumLowLowLow



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