https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-a-Rank-by-multiple-columns/m-p/2906500#M94840 <P>Hi,</P> <P>I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.</P> <P>It is for creating a new column.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">N Lap CC = RANKX ( SUMMARIZE ( FILTER ( 'Table', 'Table'[Store] = EARLIER ( 'Table'[Store] ) ), 'Table'[Date] ), 'Table'[Date], , ASC ) </LI-CODE> <P>&nbsp;</P> Tue, 15 Nov 2022 12:27:32 GMT Jihwan_Kim 2022-11-15T12:27:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-a-Rank-by-multiple-columns/m-p/2906406#M94834 <P class=""><SPAN class="">Hello, how can I add lap number column in PowerQuery or in Dax? Tour number is based on store, date, area.&nbsp;</SPAN></P><P class=""><SPAN class="">I am attaching an example of what I would like to overe in the column N Lap</SPAN></P><P class="">&nbsp;</P><P><img /></P><P>Thx</P> Tue, 15 Nov 2022 11:39:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-a-Rank-by-multiple-columns/m-p/2906406#M94834 Morrison 2022-11-15T11:39:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-a-Rank-by-multiple-columns/m-p/2906500#M94840 <P>Hi,</P> <P>I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.</P> <P>It is for creating a new column.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">N Lap CC = RANKX ( SUMMARIZE ( FILTER ( 'Table', 'Table'[Store] = EARLIER ( 'Table'[Store] ) ), 'Table'[Date] ), 'Table'[Date], , ASC ) </LI-CODE> <P>&nbsp;</P> Tue, 15 Nov 2022 12:27:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-a-Rank-by-multiple-columns/m-p/2906500#M94840 Jihwan_Kim 2022-11-15T12:27:32Z