Intermediate Power Query in Excel
Lyndsay Girard
Performance Analytics Consultant
Formula bar:
Advanced Editor:
If
... Then
... Else
statementsAND
OR
Basic Conditional Logic
if age >= 65
and arrivalmode = "Car"
then "group1"
else "group2"
If
... Then
... Else
statementsAND
OR
Custom Conditional Logic
if age >= 65 and age <= 80
and arrivalmode = "Car"
then "group1"
else if age >= 65 and age <= 80
and arrivalmode = "ambulance"
then "group1a"
else "group2"
Table.AddIndexColumn
Intermediate Power Query in Excel