Adding rows to an existing table in Power BI

I assume the SortOrder_chr (rankChr) is fixed in a table and not counted as a relative position in that table.

Each rank is decided relative to the Attri_pnl_f before and after according to Attr.._sortOrder where the rankChr is set at regDate.

When you need to insert a new row there is no available chr's between rows (..."2,3,4"...) or you need to rewrite each rankChr one higher than the one you want to replace and continue the rankUp.

To solve this you can replace all Attr.._sortOrder with new chrSets like "aaa,aba,aca.." or "100,200,300..." which gives you space to insert new rows and assign a new relative rankChr.

AlfaNum will give you 25 rows for each chr, num will give you 9.

Also, you can create a table wih just [Attr.._format] and [Attr.._sortOrder] and update new rows and rewrite each rankUpChr there whitch you then use to insert the rank into this table.