Forum Discussion

pat_energetics's avatar
pat_energetics
Advocate II
10 years ago

Percentile K argument

Is there a way of using a measure result directly in the "K" argument of the percentile function?   Where in the following example; 'Band' is a 10 row table with columns [BandNumber] of values 1-10...
prerak's avatar
prerak
Advocate I
9 years ago

Hey, So I've tried to get this to work, though when I apply my measure in such a way

 

M_TrialToPaid_PercK =
TOTALMTD
(
PERCENTILE.INC('tbl_name'[delta_purchase],
                          [M_PercK]
                          ),
  dates[actual_created],
  'tbl_name'[purchase_type]="purchase_trial"
)

 

 and

 

[M_PercK] =  IF(HASONEVALUE(bands[k]), VALUES(bands[k]), 0.5)

where column k = [0.0, 0.05. 0.1, 0.2 .... 0.9, 0.95]

 

- In other words, I'm trying to evaluate my monthly percentiles(p0, p5, p10 ... p90, p95) on the [delta_purchase] column.

-- But it just returns me the median. :mansad:

-- What I need is all the percentiles(p0, p5, p10 ... p90, p95) seperated by month.