Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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
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.
Hi @mleech
have you tried the above solution? does that work?
Also, please read this reg the sample data:
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]))
Regards,
Jimmy Tao
Thank you so much
ok, i can give a try if i can copy /paste the sample data.
Thanks
Raj
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |