Index Column Direct Query

[RhodesBrown]

Hi Guys

I'm looking to add a new column that  will index the number of related partys to an accounts, requirement below. This is so I can create an application form that uses multiple cards, but need to be able to say under Wham Co Ltd, that in score card 1 George Michaels name appears, in score 2 Bern Ltd name appears etc. Seems quite easy in import mode but cant work it out in direct query. Any assistance would be appreciated

igl_accountid	igl_relatedparty	igl_relationshiptypecodename	igl_accountidname	igl_relatedpartyname	Desire Results
624E1BA8-4CD4-ED11-A7C7-000D3AD985C1	78FD9DA1-3CD8-ED11-A7C7-000D3AD9894E	Management, Control and Ownership	Bern Ltd	Ben Mild	1
8672B4AC-A1DA-ED11-A7C7-000D3AD985C1	8572B4AC-A1DA-ED11-A7C7-000D3AD985C1	Management, Control and Ownership	Gordons Gin Limited	George Micheal	1
CA15914D-D0CE-ED11-B597-000D3AD985C1	C915914D-D0CE-ED11-B597-000D3AD985C1	Management, Control and Ownership	Music and Symphony Inc	Johannes Brahms	1
79FD9DA1-3CD8-ED11-A7C7-000D3AD9894E	78FD9DA1-3CD8-ED11-A7C7-000D3AD9894E	Management, Control and Ownership	Mild Cheese Limited	Ben Mild	1
D6002D71-1ECA-ED11-B596-000D3AD985C1	D5002D71-1ECA-ED11-B596-000D3AD985C1	Management, Control and Ownership	Wham Co Ltd	George Micheal	1
D6002D71-1ECA-ED11-B596-000D3AD985C1	624E1BA8-4CD4-ED11-A7C7-000D3AD985C1	Management, Control and Ownership	Wham Co Ltd	Bern Ltd	2
D6002D71-1ECA-ED11-B596-000D3AD985C1	GT002D71-1ECA-ED11-B596-000D3AD985C1	Management, Control and Ownership	Wham Co Ltd	George Burc	3
624E1BA8-4CD4-ED11-A7C7-000D3AD985C1	34D16E56-9F85-EC11-8D21-000D3A64FF44	Management, Control and Ownership	Bern Ltd	James Settle-Here	1

[amitchandak]

@RhodesBrown , Try to add a query and have an index created in Query using SQL, but you can not add that as a column in Power bi for that

You can also explore rownumber function released in April 2023 as a measure for the visual level index