topic Re: DAX query (index in powerBI) in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319520#M57907 <P>Thank you!&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp;</P> Fri, 04 Feb 2022 10:05:45 GMT Anonymous 2022-02-04T10:05:45Z DAX query (index in powerBI) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319451#M57900 <P>Hi all,</P><P>&nbsp;</P><P>I have a calculated column to which I would like to allot index from the highest to the lowest.</P><P>&nbsp;</P><P>For eg:</P><P>This is my table.</P><P><img /></P><P>&nbsp;</P><P>I would want EDU 1000 = index 1</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250 = 2</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 112 = 3 and so on..</P><P>&nbsp;</P><P>Can I please know how to achieve that in PowerBI?</P><P>&nbsp;</P><P>Any help is appreciated!</P><P>&nbsp;</P><P>Thank you!</P><P>Megha</P><P>&nbsp;</P> Fri, 04 Feb 2022 09:34:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319451#M57900 Anonymous 2022-02-04T09:34:18Z Re: DAX query (index in powerBI) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319455#M57901 <P>Anonymous</a> , Rank in DAX</P> <P>&nbsp;</P> <P>new column =</P> <P>Rankx(Table, [EDU],,desc,dense)</P> Fri, 04 Feb 2022 09:36:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319455#M57901 amitchandak 2022-02-04T09:36:30Z Re: DAX query (index in powerBI) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319520#M57907 <P>Thank you!&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp;</P> Fri, 04 Feb 2022 10:05:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-query-index-in-powerBI/m-p/2319520#M57907 Anonymous 2022-02-04T10:05:45Z