Forum Discussion
unnijoy
Post Prodigy
Post ProdigyPerfomance based on Quartile
I have the attriton Data based on Team Manager and country. I need to find the quartile and based on that we need to see whcih quartile the TM falls under. Fotr this i need a formula that will calcul...
Hi unnijoy ,
You can also use the attached file for Visulaization.
https://drive.google.com/open?id=12XyFQmI9bZpSXy08lgMc8EpVuwQQ42ZG
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
It's very easy.
For quartiles, you can either use the DAX functions PERCENTILE.EXC or PERCENTILE.INC or, if you want to get your hands dirty and keep your head busy, you can familiarize yourself with this page:
https://www.daxpatterns.com/statistical-patterns/
This is more than enough information for you to be able to create what you need.
Best
D