Forum Discussion

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago
Solved

“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 wee...
Need Help
  • dramus's avatar
    dramus
    8 years ago

     

    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.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi JCovelli,

 

Can you share a dummy sample please? Then people here could gave back a solution demo.

 

 

Best Regards,

Dale

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago
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
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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