Conditional multiplication based on a value in a separate column

[TuesdayApril]

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

[TuesdayApril]

Thank you, I knew it was something stupid with syntax!

[Ritaf1983 · Accepted solution]

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]

Link to the Sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly