Forum Discussion

Kazu's avatar
Kazu
Helper II
2 years ago
Solved

INDEX function and ORDERBY

I would like to define a measure which use INDEX(). The test measure blow specifies hardcoded "2" in the INDEX() function and it returns "B", which if I understand correctly is the second Name in the alphabethical order of Name. 

 

Now, how can I get the second name in the order of Sort column instead of Name column? I want "A" instead of "B" because its Sort value is "2" and considered the second". I tried to add ORDERBY like below but it did not allow me to select other columns than Name. I guess I should avoid using VALUES but use ADDCOLUMNS or something, but couldn't figure out how to do it.

 

 

 

  • I am not sure if this would be of help for anybody else, but I found a solution.

     

4 Replies

  • I am not sure if this would be of help for anybody else, but I found a solution.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Kazu 

      Glad to hear you solved the problem yourself!  

       

      Best Regards

      Yongkang Hua

       

  • Instead of VALUES('Table'[Name]) use VALUES('Table'[Sort])

    • Kazu's avatar
      Kazu
      Helper II

      Thanks but that would return "2" instead of "A". I found a solution myself.