The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |