Forum Discussion
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 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 |
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!
3 Replies
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!