Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mleech
Frequent Visitor

Identify first call of the day by agent per month

I have a table with a series of incoming call times by agent for an entire month, I need to identity the first call for each day of the month by agent.  How can I do this?

1 ACCEPTED SOLUTION

Hi mleech,

 

To achieve your requirement, create a measure using DAX as below:

First Call Receive Time = CALCULATE(MIN(Table1[Receive Time]), ALLEXCEPT(Table1, Table1[Call Date], Table1[Operator]))

 捕获.PNG

 

Regards,

Jimmy Tao

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

I dont see sample data for your qn. so am taking some guess of your data , try a calculated column like this:

 

CALCULATE ( MIN(<Time of the day or DATE Time column>), FILTER ( Table1, Table1[Agent] = EARLIER ( Table1[Agent]) && Table1[DATE] = EARLIER ( Table1[DATE])))

 

Anothjer option is,  you can use SUMMARIZE function.

 

Thanks
Raj

Thanks, sorry yes I forgot to include a sample of the data. 

 

I am trying to identify the first call of each day for each operator.

 

sample.png

Anonymous
Not applicable

Hi @mleech

 

have you tried the above solution? does that work?

 

Also, please read this reg the sample data:

https://community.powerbi.com/t5/Desktop/Best-practice-Posting-Question-with-Sample-data/m-p/470976#...

 

Thanks

Raj

I tried it and I had an error "couldn't nest EARLIER"

Hi mleech,

 

To achieve your requirement, create a measure using DAX as below:

First Call Receive Time = CALCULATE(MIN(Table1[Receive Time]), ALLEXCEPT(Table1, Table1[Call Date], Table1[Operator]))

 捕获.PNG

 

Regards,

Jimmy Tao

Thank you so much

Anonymous
Not applicable

ok, i can give a try if i can copy /paste the sample data.

 

Thanks

Raj

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.