Forum Discussion
Percentile What If calculation
I have been asked to do this in Power BI. The following table shows a Representation of my data. Grouping Identifier Value What If Value A 10 5 A 15 7.5 A 20 10 A 10 5 ...
amitchandak
Super User
Super Usersrhooey , Are you trying like this
PERCENTILE.INC(Table[value], [what if measure] )
or
measure =
var _max = maxx(allselected(whatif), whatif[value])
return
PERCENTILE.INC(Table[value],_max )