Power Query: Simply Conditional
19 August 2020
Welcome to our Power Query blog. This week I look at a method to conditionally replace values efficiently.
I have the following tent data:
I want to add a prefix to the data in my Awning column, which is dependent on the value in that column, viz.
- Blank: N/A
- Standard or Dining: Fixed
- Budget: (No prefix)
- Package or Kids: Variable.
I begin by extracting my data to Power Query using ‘From Table’ on the ‘New Query’ section of the ‘Get & Transform’ section on the Data tab.
I could use a custom column to achieve my required result:
Come back next time for more ways to use Power Query!