Forum Discussion

demonfc's avatar
demonfc
Microsoft Employee
8 years ago
Solved

Need Help - repeat contact formula

In need of help writing a formula where I can get a number of the customers my employees have helped. The formula would output the number of times an employee helped the same customer if they helped ...
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi demonfc

    Create a calculated column

    Column =
CALCULATE (
    COUNT ( Table1[Customer Name] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Employee Name] ),
        [Customer Name] = EARLIER ( Table1[Customer Name] )
    )
)

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi demonfc

Create a calculated column

Column =
CALCULATE (
    COUNT ( Table1[Customer Name] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Employee Name] ),
        [Customer Name] = EARLIER ( Table1[Customer Name] )
    )
)

 

Best Regards

Maggie