Showing results for 
Search instead for 
Did you mean: 
Post Partisan
Post Partisan

Count Visit frequency (Week & Month)

Hi BI Community Team,


I have a table name "Customer Visit Plan -- CUST_VISIT_PLAN".


In this table, we want to find/calcualte how many customer that sales rep input to visit based on frequency below. Normally we count the visit date then we can find the number of visit plan of Month not week that actually they have number of visit in the week too.


For Week -- some sales rep add visit freq 2 or 3 time at the same week.



Here is the sample pbix file - 


Any suggestion?


Thanks and Regards,


Solution Sage
Solution Sage

I have the result as in the screenshot
Screen Capture #1211.pngScreen Capture #1213.png

Super User
Super User


Based on the tables that you have shared, show the expected result very clearly.

Ashish Mathur

Hi @Ashish_Mathur ,


We want to see the summary by sales rep as the screenshot below.




Please kindly check and help.


Thanks and Regards,

Super User
Super User

Your visit_freq table is missing an index column and it has conflicting buckets.  (the latter can be dealt with if you have the former).

Hi @lbendlin ,


For time/month, it should be as the screenshot below. But time/week, I don't know to add.




Please kindly help


Thanks and Regards,

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors