Forum Discussion

Tarun-Bhatia's avatar
Tarun-Bhatia
Regular Visitor
6 years ago
Solved

Creating a Shift Column from Date-Time

Hi There   Need help in creating Shift column in PowerBi Desktop using Date-Time(READY_DATETIME) column. Shift 1: 6am - 2pm Shift 2: 2pm - 10pm Shift 3: 10pm - 6am       Any help would...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    @Tarun-Bhatia ,

    Try a new column as

    New column ?
    var _hr á hour([readydatetime])
    Return
    switch(True(),
    _hr<6 && _hr >22 , "Shift 3",
    _hr < 14 , "Shift 2",
    "Shift 1"
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

@Tarun-Bhatia ,

Try a new column as

New column ?
var _hr á hour([readydatetime])
Return
switch(True(),
_hr<6 && _hr >22 , "Shift 3",
_hr < 14 , "Shift 2",
"Shift 1"
)

  • Tarun-Bhatia's avatar
    Tarun-Bhatia
    Regular Visitor
    6 years ago

    Thanks amitchandak 

     

    I guess small issue here, Its not showing correct Shifts based on hour (Shift 1 should be between 6am - 2pm, Shift 2 between 2pm - 10pm).

    Wondering If thats because ready_datetime column shows AM/PM Instead of 24 hour?

     

    Thanks