https://community.fabric.microsoft.com/t5/Dataflow/How-can-I-add-a-column-that-ranks-my-rows-in-Dataflows/m-p/3228411#M148 <P>I have a table that looks like the following:</P><P>Team Total Points Bonus modifier</P><TABLE><TBODY><TR><TD>A</TD><TD>20</TD><TD>0.5</TD></TR><TR><TD>B</TD><TD>30</TD><TD>0.8</TD></TR><TR><TD>C</TD><TD>40</TD><TD>0.2</TD></TR><TR><TD>D</TD><TD>10</TD><TD>0.45</TD></TR><TR><TD>E</TD><TD>20</TD><TD>0.75</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><SPAN>&nbsp;I want add a column that ranks the teams using the values from the&nbsp;</SPAN>Total Points<SPAN>&nbsp;and&nbsp;</SPAN>Bonus modifier<SPAN>&nbsp;fields. How can I do this in Dataflows?</SPAN></P> Fri, 19 May 2023 16:41:11 GMT miguel 2023-05-19T16:41:11Z https://community.fabric.microsoft.com/t5/Dataflow/How-can-I-add-a-column-that-ranks-my-rows-in-Dataflows/m-p/3228411#M148 <P>I have a table that looks like the following:</P><P>Team Total Points Bonus modifier</P><TABLE><TBODY><TR><TD>A</TD><TD>20</TD><TD>0.5</TD></TR><TR><TD>B</TD><TD>30</TD><TD>0.8</TD></TR><TR><TD>C</TD><TD>40</TD><TD>0.2</TD></TR><TR><TD>D</TD><TD>10</TD><TD>0.45</TD></TR><TR><TD>E</TD><TD>20</TD><TD>0.75</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><SPAN>&nbsp;I want add a column that ranks the teams using the values from the&nbsp;</SPAN>Total Points<SPAN>&nbsp;and&nbsp;</SPAN>Bonus modifier<SPAN>&nbsp;fields. How can I do this in Dataflows?</SPAN></P> Fri, 19 May 2023 16:41:11 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-can-I-add-a-column-that-ranks-my-rows-in-Dataflows/m-p/3228411#M148 miguel 2023-05-19T16:41:11Z https://community.fabric.microsoft.com/t5/Dataflow/How-can-I-add-a-column-that-ranks-my-rows-in-Dataflows/m-p/3228415#M149 <P>You can use the <A href="https://learn.microsoft.com/power-query/rank-column" target="_self">Rank column feature</A> inside of Dataflows and also define what rank method you'd like to use.</P><P><img /></P> Wed, 10 May 2023 08:49:19 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-can-I-add-a-column-that-ranks-my-rows-in-Dataflows/m-p/3228415#M149 miguel 2023-05-10T08:49:19Z