Forum Discussion

micky123's avatar
micky123
Frequent Visitor
8 years ago
Solved

Percentile table like Excel

Hi everyone,   I am trying to create a percentile table in Powerbi but having trouble doing that.   Below screenshot shows the Excel version:     From this we can see that my percentile ...
Need Help
Tips and Tricks
  • micky123's avatar
    micky123
    8 years ago

    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

micky123's avatar
micky123
Frequent Visitor
8 years ago

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

McCow's avatar
McCow
Resolver III
8 years ago

And micky123

I'm not sure if you somehow can use it, but u can try experiment with this formula:

cost_percentileC2 = PERCENTILEX.INC(
	CALCULATETABLE(
		stats_prod;	FILTER(stats_prod;stats_prod[_Size]>0); //from min
				FILTER(stats_prod;stats_prod[_Size]<100000) //to max
		); // filter-table
	stats_prod[cost];[Value]
)//end PERCENTILEX.INC

 

where Filter definition create low and high (min and max) data border from your data set.

 

Enjoy!