Forum Discussion
Kazu
2 years agoHelper II
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.