Forum Discussion
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 = "Overtime", for all other timesheetytpes the value is fine as is for Cost Rate. The keeping the correct values in the new column is the confusing part.
Something like If timesheetentrytype ="Overtime" then Cost Rate x 1.5, else keep current value of Cost Rate
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
2 Replies
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
Thank you, I knew it was something stupid with syntax!
