Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
203
Views
Topic starter
Hi !
how can i make function like excel in the power query
the excel function is :
=IF(AND(U3>=TIME(6,0,0), U3<=TIME(15,0,0)), "Morning", IF(AND(U3>=TIME(15,1,0), U3<=TIME(23,0,0)), "Evening",
"Night"))
U3 = COLUMN with time_for_shift_segmentation LIKE 10:59:00 I mean, based on the time, I want to know which shift it belongs.
Posted : 25/04/2023 4:48 am
Hi Moshe,
See in attachment.
BR,
Lionel
Posted : 25/04/2023 6:20 am
Topic starter
Thank you Lionel 🙂
Posted : 26/04/2023 1:34 am