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.

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
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.

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

Thanks Rob for Solving the riddle!

 

John