Forum Discussion

baqerbushajea's avatar
baqerbushajea
Regular Visitor
6 years ago
Solved

create shifts by agents with interference

Hello guys,  i have call center log files i would like to divide agents into two shifts (morning , night ), Morning start from 8:00AM ends 4:00PM  Night start from 1:00 PM ends 9:00PM , i understan...
Need Help
Show and Tell
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago

    Try something like this, as COLUMNS: 

     

    FirstCallTime = MINX(FILTER('Calls Log', 'Calls Log'[Call Date]=EARLIER('Calls Log'[Call Date]) && 'Calls Log'[Agent]=EARLIER('Calls Log'[Agent])),'Calls Log'[Call Time])
    Shift = IF('Calls Log'[FirstCallTime]<TIMEVALUE ( "1:00 PM" ),"Morning", "Night")
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

baqerbushajea ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

baqerbushajea's avatar
baqerbushajea
Regular Visitor
6 years ago

idid create this code 

 

Shift =

if('Calls log'[Call Time] < TIMEVALUE ( "1:00 PM" ),"Morning"
        ,IF('Calls log'[Call Time] > TIMEVALUE("4:00 PM") ,"Night" , "Morning "))
Unfortunately dosen't work , 
 
  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Try something like this, as COLUMNS: 

     

    FirstCallTime = MINX(FILTER('Calls Log', 'Calls Log'[Call Date]=EARLIER('Calls Log'[Call Date]) && 'Calls Log'[Agent]=EARLIER('Calls Log'[Agent])),'Calls Log'[Call Time])
    Shift = IF('Calls Log'[FirstCallTime]<TIMEVALUE ( "1:00 PM" ),"Morning", "Night")