Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
@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