Good morning! I need your help with calculating 99 persentile for values for a changing time period. I select a date range in the slicer and the persentile for that time in the table should be calculated. I tried creating a measure with the formula "Percentile = PERCENTILE.INC('public history'[Value], 0.99)" but I need to end up with a single value, not for each point in time from that date range.
I'm counting on your help!
Hi @pg151307 -adjust measure to calculate a single 99th percentile value for a selected date range in Power BI
Percentile99 =
VAR SelectedValues =
CALCULATETABLE(
'public history',
ALLSELECTED('public history'[Date])
)
RETURN
PERCENTILEX.INC(SelectedValues, 'public history'[Value], 0.99)
Hope this approch works, check it.
Proud to be a Super User! |  |
Hi @pg151307 -adjust measure to calculate a single 99th percentile value for a selected date range in Power BI
Percentile99 =
VAR SelectedValues =
CALCULATETABLE(
'public history',
ALLSELECTED('public history'[Date])
)
RETURN
PERCENTILEX.INC(SelectedValues, 'public history'[Value], 0.99)
Hope this approch works, check it.
Proud to be a Super User! | |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
