topic Re: INDEX function and ORDERBY in DAX Commands and Tips

INDEX function and ORDERBY

Kazu — Wed, 12 Jun 2024 22:37:46 GMT

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.

Re: INDEX function and ORDERBY

lbendlin — Thu, 13 Jun 2024 01:56:44 GMT

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

Re: INDEX function and ORDERBY

Kazu — Thu, 13 Jun 2024 02:07:55 GMT

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

Re: INDEX function and ORDERBY

Kazu — Thu, 13 Jun 2024 02:13:08 GMT

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

Re: INDEX function and ORDERBY

Anonymous — Thu, 13 Jun 2024 02:31:35 GMT

Hi, Kazu

Glad to hear you solved the problem yourself!

Best Regards

Yongkang Hua