Forum Discussion
Need help. Percentile for each row
Hello!
I have the next data table:
DATE NAME VALUE
17/01/01 s1 23
17/01/02 s1 18
17/01/01 s2 30
17/01/02 s2 12
...
I am tried the next function, but no work
GROUPBY(table;table[name];"percentil";PERCENTILEX.EXC(CURRENTGROUP();table[value];0.9))
My objective is to calculate the k-percentile for each name
Any idea?
Thank you very much.
1 Reply
Create the following measures in your table and check if they return your expected result. If not, please post your desired result based on your sample table.
sumvalue = SUM(Table[Value])
Measure = PERCENTILEX.EXC(Table,Table[sumvalue],0.90)
Regards,
