I Would like count customer numbers between two dates

[Anonymous]

I would like to know how many customers are newly joined from this month first to today,Can someone help me on this

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Want-to-calculate-number-of-new-customers-per-every-month-of-the/m-p/349689#M157111

[Anonymous]

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

[rocky09]

you will get the required results if you use Slicer.