Forum Discussion
Count unique Values in a month
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]))
)
)
Hi Kate_McCulloch,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround so that other users can benefit as well. And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi Apologies, we had alot of system issues last week, the solution from bhaunu_gautam worked to a point but was having issues with a couple not calculating correctly. I wasn't able to further test anything due to the issues last week
Hi Kate_McCulloch,
Can you please confirm once you are able to go through the response provided. Also if you need any help, we’re happy to keep working with you on this.
Best Regards,
Hammad.
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.
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.