Forum Discussion
Power Query - Add column with multiplcation based on criteria from another column
Imagine I have a table that looks like the following: Col A Col B Col C Col D Bonus Data 35 35 Bonus Data 45 45 Salary Data 55 62.59 Salary Data 85 96.73 Holiday ...
Hi,
You should be able to add a custom column like this:
if [Col A] = "Salary" then [Col C] * 1.138 else [Col C]
Pete