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
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |