Percentile 80 in Dax (Excel 2013 Version)

FelipeVaz

New Member
Joined
Sep 30, 2014
Messages
37
[FONT=&quot] I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] Col1 qtd cons qtd/cons[/FONT]
A20250,80
A12150,80
A8260,31
A10240,42
B19200,95
B19141,36
B7170,41
C18210,86
C8180,44
C17250,68
D5150,33

<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>
[FONT=&quot] [/FONT]
[FONT=&quot]The nem column should looks like this [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Col1 qtd cons qtd/cons Perc80[/FONT]
A20250,800,8000
A12150,800,8000
A8260,310,8000
A10240,420,8000
B19200,951,1943
B19141,361,1943
B7170,411,1943
C18210,860,7863
C8180,440,7863
C17250,680,7863
D5150,330,3333

<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>
 

Forum statistics

Threads
1,085,917
Messages
5,386,778
Members
402,019
Latest member
JLuby

Some videos you may like

This Week's Hot Topics

Top