Forum Discussion
Percentile table like Excel
McCow Thanks for explination, I have tried to follow the same steps for prod data and there seems to be issue.
Could you point out what I am doing wrong please? Here's the updated pbi file: https://1drv.ms/u/s!Aghc93erq8rBcUhH5N_y1X_MXN8
I have created 3 new tables exactly in the same structure:
size_prod, stats_prod, Persentille_prod
Thanks again for your time, patience. I am learning alot from you!Kind Regards
I have done some research and found out that this is the dax I need to use to calculate percentile but not sure how to adapt it for each percentile group: = PERCENTILEX.INC(<table>, <expression>;, k)
Does anyone know how I can have a dynamic value for "k"?
Thanks
Hi micky123,
to build a column like your example, you can create DAX table (for ex. PersentilleT):
PersentilleT = UNION(GENERATESERIES(0;0,05;0,01);GENERATESERIES(0,1;0,9;0,05);GENERATESERIES(0,91;1;0,01))
Now you have one-column table with "Value" column.
And as second calculated column you can use this formula:
Column = PERCENTILEX.INC(Table1;Table1[Cost];[Value])
It's all as you need?
P.S. for dynamic k-value you need to build a measure. It' is a little complicated approach.
Best Regs
McCow Thanks this was helpful and I think I am getting close to what I am trying to do.
I am unable to get this work
Column = PERCENTILEX.INC(Table1;Table1[Cost];[Value])
I have created a sample PowerBI file using your suggestion. URL: https://1drv.ms/u/s!Aghc93erq8rBcLygGX6qE2p7zXY
Please let me know if this simplify what I am after.
Thanks
Hi micky123
good job, you was a pretty near.
i corrected you PBIX example and send back, LOOK HERE:
Two remarks:
1) The percentile calculation must be a column, not measure (see above)
2) The source Data type must be "Decimal" not Whole (see bellow):
And i added extra columns for better understanding you troubles. It can be leaved to better understanding, what i did. Enjoy!
If you have a questions ask back.
Best regs