Forum Discussion
Custom column
Hi All
I am attempting to get this custom column in Power Query however not quite correct
= Table.AddColumn(#"Changed Type1", "Rate", each if [Shift Start] < #time(18, 1, 0) then "Evening Rate"
if [Shift end] > #time(18, 0, 0) then "Day Rate" else if [Shift End] < #time(18, 1, 0) then "Evening Rate"
If [Shift Start] < #time (05,59,0) then "Evening Rate" else ifIf [Shift Start] < #time (06,00,0) then "Day Rate"
and if [Shift Start] > #time (05,59,0) then "Evening Rate" else null)
else if [Shift Finish] > #time(18, 1, 0) then "Evening Rate" else null)
| Shift Start | Sleepover Start | Sleepover Finish | Allocated Shift Break (mins) | Shift Finish | Worked Hours in Day | Shift Splits | Total shift hours | Week | Day |
| 9:15 AM | 0 | 1:15 PM | 4.00 | 4 | 1 | Thursday | |||
| 9:15 AM | 0 | 1:15 PM | 4.00 | 4 | 2 | Thursday | |||
| 9:00 AM | 0 | 1:00 PM | 4.00 | 4 | 1 | Tuesday | |||
| 9:15 AM | 0 | 1:15 PM | 4.00 | 4 | 1 | Wednesday |
1 Reply
Your sample data doesn't match your description. Please check, and please also indicate the expected outcome based on the sample data.
