Please help with power query conditional column

[pborah]

I'm trying to group time data into day shift and night shift using custom column in power query

I tried a few variations but can't seem to get it right. The conditional statement either executes but has no results or there's some syntax error that does now allow me to execute the statement. The statement has a logical operator AND in it so I can't use the "conditional column" in power query.

 

The last one executes, but the resultant column simply shows "Error" instead of values. Thank you.

[Idrissshatila · Accepted solution]

Hello @pborah ,

try the following custom column

if DateTime.Time([received_time]) >= #time(6,0,0) and DateTime.Time([received_time]) < #time(18,0,0)  then "Day" else "Night"

[Ritaf1983]

Hi @pborah 
Please refer to the solution of @amitchandak  in the linked discussion :
https://community.fabric.microsoft.com/t5/Desktop/M-Query-If-Statement-for-Dates-and-time/td-p/17860...

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