Forum Discussion

NicolasF26's avatar
NicolasF26
Regular Visitor
3 years ago
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...
Need Help
  • JohnShepherdAPD's avatar
    JohnShepherdAPD
    3 years ago

    Hi Nicolas,

    This DAX should do the trick:

    SecondDistinct = 
INDEX(2,DISTINCT(DistinctList[List]),ORDERBY(DistinctList[List]))

     

JohnShepherdAPD's avatar
JohnShepherdAPD
Helper II
3 years ago

Hi Nicolas,

This DAX should do the trick:

SecondDistinct = 
INDEX(2,DISTINCT(DistinctList[List]),ORDERBY(DistinctList[List]))

 

  • NicolasF26's avatar
    NicolasF26
    Regular Visitor
    3 years ago

    Thanks a lot John, That was what I was doing but my data were wrong (not the formula), but your help make me find the mistake.

     

    Thanks again

    Buy