Using a switch style to replace nested ifs

PHOTO EMBED

Mon Feb 24 2025 15:54:33 GMT+0000 (Coordinated Universal Time)

Saved by @davidb2107 #power_query

let
  Conditions = {
    [ColumnName] = "1501", 
    [ColumnName] = "1500", 
    [ColumnName] >= "1100" and [ColumnName] < "1200"
  }, 
  Results = {"FFPC", "PCFam", "Différentielle"}
in
  Results{List.PositionOf(Conditions, true)}
content_copyCOPY