Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a summary table called, YF_Summary. So while trying to use the built-in median function, the answer was wrong. So i tried to use the manaul formula to calculate median. My requirement is to find the Median of the Unique_Quotes field for last 30 days(this will not change, its 30 always, so median will always be [15throw+16th row]/2. I have applied the filter to the table visual which will select only the last 30 days(exclude today). I used the below query ,
DAX Query:
Since there are many values repeating it for the consecutive rows/dates, there is no 15th and 16th rank, so it returns blank as answer.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |