Forum Discussion
“Frequent Caller” metric
Hello Group!
Does anyone know how I might use DAX or Power BI to calculate our “Frequent Caller” metric here at work?… we say that anyone of our members who has called us more than one time in a week is a “Frequent Caller”… the data set is made of rows, each row is a call, with the date of the call. The DAX calculation would need to know if the caller has called previously, and within 7 days of the previous call… any ideas?
I created a new summarize table:
Last Called = summarize(Calls,Calls[Caller],"Last Called",max('Calls'[Date]))Then I added a new Column:
Frequent Caller = if(countx(filter(Calls,datediff([Date],'Last Called'[Last Called],DAY)<=7 && [Caller]='Last Called'[Caller]),[Caller])> 1,"Yes","No")
Here's a pic of the report.
13 Replies
Hello!
I get the data from a SQL query, and there is a time date field with a time stamp in it. I usually do ,CAST(INTERACTION.PXCREATEDATETIME as DATE) so that I can group by DAY in a pivot table, but I can alos just leave it with the timestamp in it.
Thanks!
John
Hi JCovelli,
Do you want to count the number of calls made in the same day as frequent calls or just on multiple days?
Hi JCovelli,
Can you share a dummy sample please? Then people here could gave back a solution demo.
Best Regards,
Dale
- Hi Dale, I do not see a place to attach a file, nor insert a screen shot... what is the procedure for sharing with you? John
Hi JCovelli,
I would suggest you create dummy sample, then you can share it with all of us. You can upload your file to the cloud drive like OneDrive, GoogleDrive and post the download link here. Or send us a private messages.
Best Regards,
Dale
