Forum Discussion

Kate_McCulloch's avatar
Kate_McCulloch
Regular Visitor
1 year ago
Solved

Count unique Values in a month

I'm trying to count how many contacts a person has had in a month, the end column is what I would like it to calculate but struggling to find a measure to do this, can anyone help.        T...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Kate_McCulloch , Try using

     

    Contacts in Month =
    CALCULATE(
    COUNT('Table'[Contact Date]),
    FILTER(
    'Table',
    'Table'[UNIQUE ID] = EARLIER('Table'[UNIQUE ID]) &&
    MONTH('Table'[Contact Date]) = MONTH(EARLIER('Table'[Contact Date])) &&
    YEAR('Table'[Contact Date]) = YEAR(EARLIER('Table'[Contact Date]))
    )
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Kate_McCulloch,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if you were able to go through the response provided.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

 

Best Regards,

Hammad.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Kate_McCulloch,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

 

Best Regards,

Hammad.