topic Re: Changing my weakth quintile percentile to five categories in DAX Commands and Tips

Changing my weakth quintile percentile to five categories

Geteneh — Thu, 12 Oct 2023 12:47:21 GMT

Dear team

Could you support me how to convert my percentiles values to five categories?

See attached

Re: Changing my weakth quintile percentile to five categories

DallasBaba — Thu, 12 Oct 2023 16:13:38 GMT

GetenehYou can change the column from text to a Decimal number and set the number on decimal you would like to display.

You can use the following code to set a dynamic category base on your preference

Category =

SWITCH(TRUE(),

[IWItot] <= PERCENTILE.INC([IWItot], 0.2), "Very Low",

[IWItot] <= PERCENTILE.INC([IWItot], 0.4), "Low",

[IWItot] <= PERCENTILE.INC([IWItot], 0.6), "Moderate",

[IWItot] <= PERCENTILE.INC([IWItot], 0.8), "High",

[IWItot] <= MAX([IWItot]), "Very High"

)

Let me know if this works

Thanks

Re: Changing my weakth quintile percentile to five categories

Geteneh — Tue, 17 Oct 2023 10:21:42 GMT

Thank you, it works now

Re: Changing my weakth quintile percentile to five categories

DallasBaba — Tue, 17 Oct 2023 14:15:49 GMT

Geteneh Thanks for letting me know this works for you.

Kindly Like the post and consider accept it as the solution  to help the other members find it more quickly.

Thanks
Dallas