Help with DAX - Customer that didn't call in 48hrs

ROG — Tue, 31 Jan 2023 13:43:14 GMT

Hello guys,

I have a list os customers numbers, and I need to create a dax to get me the number of Answered calls from customers who didn't call in 48 hours. This will give me a 100% first call resolution.

Below is the logic, which I already have the number of Answered calls and the Total answered, but how I can identify a number that called after 2 days from the 1st call?

Formula = Answered calls (didn’t call in 48h) / Total answered.

Many thanks!

Re: Help with DAX - Customer that didn't call in 48hrs

FreemanZ — Wed, 01 Feb 2023 08:32:42 GMT

hi ROG

Please consider providing sample dataset with expected result to well reflect your challenge.

topic Help with DAX - Customer that didn't call in 48hrs in DAX Commands and Tips

Help with DAX - Customer that didn't call in 48hrs

Re: Help with DAX - Customer that didn't call in 48hrs