thiscodeWorks - Organizing the best of code online

List view

Using a switch style to replace nested ifs

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

#power_query

Promote headers before expanding tables

Table.TransformColumns(Source, {{"Data", each Table.PromoteHeaders(_), type table}})

Using a switch style to replace nested ifs

Promote headers before expanding tables

Save snippets that work with our extensions