Forum Discussion
Solved
Index DISTINCT values
Hello, I thought my question was an easy question, but I don't get what I doing wrong. I want to use DAX to find the second (or third, ect...) occurrence in a list of unique values. So we...
Hi Nicolas,
This DAX should do the trick:
SecondDistinct = INDEX(2,DISTINCT(DistinctList[List]),ORDERBY(DistinctList[List]))
NicolasF26 See if this helps: The Mythical DAX Index - Microsoft Power BI Community