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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Active & Inactive customers

Hi, everyone,

 

 

I have to calculate the active & inactive customers count whereas active customer id is 0 and inactive customer id is 1...

on the basis of time (year, month & quarter)

 

so they can select any year & see which customers and how many customers are active and inactive in this period of time.

 

Kindly Help

 

Customer CodeCustomer NameBlockedLast Date Modified
Csut 01XYZ 01002/07/2020
Cust 02XYZ 02104/02/2020
Csut 02XYZ 03007/06/2020
Cust 03XYZ 04010/06/2020
Csut 03XYZ 05002/07/2020
Cust 04XYZ 06110/06/2020
Csut 04XYZ 07110/06/2020
Cust 05XYZ 08110/06/2020
Csut 05XYZ 09110/06/2020
1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

HI @Anonymous ,

 

You can drag and create a Slicer  the Year Month and Quarter from Date Table.

 

You can also create  a Slicer for Active and Inacive customers.

 

Just create a measure

 

Count of Customers = Count(Table [Customer Code]).

 

 

Users can select the slicers and so the different slicing and dicing as needed.

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)


Did I answer your question? Mark my post as a solution!

View solution in original post

3 REPLIES 3
harshnathani
Community Champion
Community Champion

HI @Anonymous ,

 

You can drag and create a Slicer  the Year Month and Quarter from Date Table.

 

You can also create  a Slicer for Active and Inacive customers.

 

Just create a measure

 

Count of Customers = Count(Table [Customer Code]).

 

 

Users can select the slicers and so the different slicing and dicing as needed.

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)


Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

Sir, Kindly also tell the measure that i can calculate when user click to year month or quarter so they can see how many new customers added in that perticular periods of time...

Hi @Anonymous ,

 

 

If you are using a slicer

 

Just use the measure

 

New Customers = CALCULATE(Count('Table' [Customer Code]), 'Table'[Name Blocked] = 1))

 

 

Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.