Forum Discussion
identify missed calls
- Anonymous1 year ago
Hi, Lodewyk
Thanks your reply.
Please refer to the new DAX formula:
ReturnedStatus2 = SUMMARIZE ( ADDCOLUMNS ( FILTER ( GENERATE ( SELECTCOLUMNS ( FILTER ( 'Table1', CONTAINSSTRING ( 'Table1'[From], "miss caller" ) ), "_To1", 'Table1'[To], "_From1", 'Table1'[From], "_result1", 'Table1'[Result], "_Date1", 'Table1'[Date/Time] ), SELECTCOLUMNS ( FILTER ( 'Table1', CONTAINSSTRING ( 'Table1'[From], "receiver" ) ), "_To2", 'Table1'[To], "_From2", 'Table1'[From], "_Date2", 'Table1'[Date/Time], "_result2", 'Table1'[Result] ) ), [_From1] = [_To2] ), "ReturnedWithin3Days", IF ( DATEDIFF ( [_Date1], [_Date2], DAY ) <= 3 && [_result2] = "answered", "Returned", "No Returned" ) ), [_From1], [ReturnedWithin3Days] )
I have updated the new pbix file below, hope this helps.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Lodewyk ,
You can create the measure to count the number of missed calls returned within 3 days like the below
CountReturnedCallsWithin3Days =
CALCULATE(
COUNTROWS('Calls'),
FILTER(
'Calls',
'Calls'[Result] = "missed" &&
'Calls'[ReturnedWithin3Days] = "Returned"))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Thanks for the advise. Question, where do you define the date difference between when the miss call came in and when it was returned?