Go to Solution.
Hi @hawb ,
VAR N = 5
VAR Percentiles =
GENERATESERIES ( 1, N ),
"Percentile", PERCENTILEx.INC ( FILTER('Table',EARLIER('Table'[Fish Species])='Table'[Fish Species]),'Table'[Length. e.g], [Value] / N )
MINX ( FILTER ( Percentiles, 'Table'[Length. e.g] <= [Percentile] ), [Value] )
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Not very Clear. Refer if my Video and file(attached after signature) can help
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.