Power Query: if null syntax
let
buffer = Table.Buffer(demographicsCombined),
Source = Table.AddColumn(
people,
"First Name",
each buffer{[ Person Number = [Employee Number]]} ? [First Name] ?
)
in
Source
let
Source = Excel CurrentWorkbook(){[Name = "Employee"]}[Content],
Criteria = Excel CurrentWorkbook(){[Name = "Criteria"]}[Content],
Return = Table.AddColumn(
Source,
"Description",
each Criteria{[Performance = [Performance]]} ? [Description] ? ?? "Unsatisfactory"
)
in
Return