Identify first call of the day by agent per month

[mleech]

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?

[Anonymous]

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

[mleech]

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.

[Anonymous]

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

[mleech]

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

[v-yuta-msft · 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]))

 

Regards,

Jimmy Tao

[mleech]

Thank you so much

[Anonymous]

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

Thanks

Raj