Add Index based on 2 x Columns - Power BI
community.powerbi.com › t5 › DesktopJun 18, 2020 · Desktop Add Index based on 2 x Columns Reply Topic Options hackfifi Helper V Add Index based on 2 x Columns 06-18-2020 01:13 PM Hi - Just need some help to create the INDEX column. It should be a sequence number sorted on Period but resets when Project Changes. Happy to use a calculated column or adding it to the Power Query table. Thanks!! Solved!
Add an index column - Power Query | Microsoft Learn
learn.microsoft.com › power-query › add-index-columnDec 17, 2022 · Step 3. Add an integer-divide column from the index column. Select the Index column, go to the Add column tab, and then select Standard > Divide (Integer). In the Integer-divide dialog box, enter a number by which to divide each value in the column. In this case, your pattern repeats itself every three rows, so enter the value 3. Remove the Index column, because you no longer need it. Your table now looks like the following image.