Dyota's blog

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

#powerquery