Active & Inactive customers

[Anonymous]

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 Code	Customer Name	Blocked	Last Date Modified
Csut 01	XYZ 01	0	02/07/2020
Cust 02	XYZ 02	1	04/02/2020
Csut 02	XYZ 03	0	07/06/2020
Cust 03	XYZ 04	0	10/06/2020
Csut 03	XYZ 05	0	02/07/2020
Cust 04	XYZ 06	1	10/06/2020
Csut 04	XYZ 07	1	10/06/2020
Cust 05	XYZ 08	1	10/06/2020
Csut 05	XYZ 09	1	10/06/2020

[harshnathani · Accepted solution]

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]

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...

[harshnathani]

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!