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