Showing results for 
Search instead for 
Did you mean: 
New Member

Automate the count of the total active clients( IN THE LAST 30 DAYS)

Hello guys good morning. I started working with Power BI in 2 weeks and my task here at the enterprise is to automate the weekly report that they need to send to the investors. Well I have a problem. In this segment of the report, I need to present the count of the total active clients( IN THE LAST 30 DAYS) . How I do this is simple. Just need to remove the duplicates and blanks from one specific column, in my table, and then use count rows and I have the Total number. I did that is easy, but the thing is that it need to be automatic, for example when I receive a batch of the last 7 days, automatically I need that total number without going to the table and repeat the process of remove duplicates and blanks and the count rows for that period of time.   What suggestions do you have? I have created the time table and I can with that use a slicer that give some specific 30 days of my database, but I need to create a measure or something that when I choose those 30 days automatically show me in a card for example the total active clients. ( remove duplicates + blanks , and the count the rows).

Thank you!


Hi @Casan3va,

Could you please post me some sample file and post your desired result if possible?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.