Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |