I want to create a new column (Role_Order) in the existing table connected via import mode in Power BI.
The new column should have serial number, but it should start with 1 for every unique email and fill the series down. Is there any way to do it in power query editor.
