Forum Discussion

gkir's avatar
gkir
Icon for Advocate II rankAdvocate II
4 years ago

DAX. Find value based on rankx

Hello,   Can someone help me with Dax? I have a table with values. Each item every day has no more than 1 value:   I need to calculate rolling 3 year median for every item. The problem i...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Thanks for the data sample. Can you please explain how you wish to calculate the median? I don't quite understand the statement reading

"The problem is that the median which I need is calculated not arithmetically, but negative values should be the worst, then the large positives and the best values are small positives"

Maybe if you provide a practical example?

gkir's avatar
gkir
Icon for Advocate II rankAdvocate II
4 years ago

For example:
Item A has values:
-2
3
6
8
9

Arithmetical median would be: 6.

but we want to rank like this:
-2
9
8
6
3

So our median is 8.