Forum Discussion

Icon for Solution Specialist rank

Solution Specialist

5 years ago

Solved

Counting New Customer per day

Dear Concern,

I have date column and customer ID as prvcusID column

I want to find every day how many customer newly created, I attached screen shot

Fowmy
5 years ago
abc_777

Make sure, you have only DOE column and add the measure. Check an example below.
abc_777
5 years ago
Fowmy
perfect I had mistakenly took customer name which I shouldn't.
Thanks for your support. Really great.

6 Replies

Fowmy
Super User
5 years ago
abc_777

Add a Table visual to the canvas, drag and drop the Date (DOE) and prvcusID fields. Click on the down-arrow in prvcusID field and choose count.

or

You can also create a measure:

Count Customers = COUNT(Table1[prvcusID])
- abc_777
  Solution Specialist
  5 years ago
  Fowmy
  I have created measure but resure not as I expected. I want total of each day. like on 2nd of May I have 10 customers newly created or 4th of may I have two customers newly created. screen shot attached
  - Fowmy
    Super User
    5 years ago
    abc_777
    Remove PrvCusID column as you need to see by date.
    By keeping only Date and the Count Measure, you can see the number of customers by date, if you add more fields, it will filter by them as well.