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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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