Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
abc_777
Solution Specialist
Solution Specialist

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

 

1.JPG

2 ACCEPTED SOLUTIONS

@abc_777 

Make sure, you have only DOE column and add the measure. Check an example below. 

Fowmy_0-1622385807178.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

abc_777
Solution Specialist
Solution Specialist

@Fowmy 

perfect I had mistakenly took customer name which I shouldn't.

Thanks for your support. Really great.

View solution in original post

6 REPLIES 6
Fowmy
Super User
Super User

@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])

 

Fowmy_0-1622380711972.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

abc_777
Solution Specialist
Solution Specialist

@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 attached2.JPG3.JPG

@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.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

abc_777
Solution Specialist
Solution Specialist

@Fowmy 

thanks for your reply and help but really dont know what happened. I did this as you said removed prvcusid and make this column as count as well as create measure but still bad luck. not sure where the isseu is.1.JPG2.JPG

@abc_777 

Make sure, you have only DOE column and add the measure. Check an example below. 

Fowmy_0-1622385807178.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

abc_777
Solution Specialist
Solution Specialist

@Fowmy 

perfect I had mistakenly took customer name which I shouldn't.

Thanks for your support. Really great.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.