Forum Discussion
Active & Inactive customers
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!