Forum Discussion
I Would like count customer numbers between two dates
I would like to know how many customers are newly joined from this month first to today,Can someone help me on this
Anonymous ,
You may refer to the following post.
3 Replies
- rocky09
Solution Sage
you will get the required results if you use Slicer. Hi Anonymous
You can create a calculate column
CalculateColumn = IF(YEAR(Sheet2[Date]) = YEAR(NOW()) && MONTH(Sheet2[Date]) = MONTH(NOW()), 1, 0)Then use this column as filter and set filter value as 1. Then take the count of your customer ID or name. this will givge the total customers for current month from 1 to till date.If this solution solves your problem then mark this as solution and give the kudos.Thanks
v-chuncz-msftCommunity Support
Anonymous ,
You may refer to the following post.
