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,
Thanks for reaching out to the Microsoft fabric community forum. It seems you want to calculate for each row (person + contact date), the count of how many contacts that same person had in that same calendar month (and year). As Cookistador has responded to your query with a measure, kindly go through his response and check if your issue can be resolved.
I would also take a moment to thank Cookistador and bhanu_gautam, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
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.
