Forum Discussion
Solved
Conditional multiplication based on a value in a separate column
Hi all, I need a Custom Column in Power Query, seems easy, struggling. Below is the data. Basically, I have a 'Cost Rate' that needs to have 1.5 times the current value when Timesheetentrytype = ...
Hi TuesdayApril
To achieve your goal please add a custom column with the formula:
if [TimesheetEntryType]="Overtime" then [Cost rate]*1.5
else [Cost rate]If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi TuesdayApril
To achieve your goal please add a custom column with the formula:
if [TimesheetEntryType]="Overtime" then [Cost rate]*1.5
else [Cost rate]
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly