Forum Discussion
Solved
Please help with power query conditional column
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 ...
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/1786038If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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"
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/1786038
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.