Search found 2 matches

by erock24
Sat Nov 23, 2019 4:18 am
Forum: PowerPivot/DAX
Topic: Dynamic Percentile - Year or Month
Replies: 3
Views: 310

Re: Dynamic Percentile - Year or Month

This is not the right calculation. Not sure what your measures are doing, but the end calculation should tie back exactly to what I show in GREEN in my attachment. Is it even possible to jump from the raw data to the green table? It might not be.
by erock24
Mon Nov 18, 2019 12:55 am
Forum: PowerPivot/DAX
Topic: Dynamic Percentile - Year or Month
Replies: 3
Views: 310

Dynamic Percentile - Year or Month

I have iteration data: Iteration, Year, Month, Type, Value. Can ignore the Type field, it's the same for each iteration. Iteration field contains 201 entries, with iterations 1-200 I am looking for a measure that will calculate percentile. I need to calc Max, Min, P95, P5, and P50. In excel if I use...

Go to advanced search

cron