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
Solved! Go to Solution.
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.
You can also create a measure:
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
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.