Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 |
Solved! Go to 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!
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!
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |