BI Consultant
BI Consultant, Power BI, MS Excel, Trainer
  • @imVivRan

PowerQuery QuickBytes # 3 - Conditional Column in Power Query

Updated: May 29, 2019

Bye bye Nested IFs


During expectation settings of any MS Excel training, I ask participants what they want to learn from the training. If I create a list of all such topics and rank them, IF or Nested IFs can easily occupy one of the top 5 slots. Although simple formula, many excel users find IF formula is quite intimidating.


So, I decided to dedicate my third video in this series to it.


Power Query, in general, has simplified most of the complicated Excel features and IF formula is one of them. It is known as CONDITIONAL COLUMN (under Add Column) in Power Query.

All we need to worry about is defining the conditions accurately and Power Query will take care of the rest.

Please watch the video for a step-by-step guide to CONDITIONAL COLUMN in Power Query



Download the sample file from: https://www.vivran.in/downloads


File Name: Sample Data 2



#PowerQuery #NestedIFs #QuickBytes #MSExcel