Forum Discussion
Solved
counting records per user
hi, i have a table that contain the fo,owing colums: name date jonthan 19/11/2017 jonthan 20/11/2017 josef 20/11/2017 omar 20/11/2017 jonthan ...
Hi davidi4524,
Look at your original question carefully - COUNT is exactly what you wanted. Anyways, for your changed question now, try this
=DISTINCTCOUNT(Data[Date])
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.
ok but i need to count distinct the numbers of the records per the username between dates. this solusion is only make a subtotal per username
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.