Hi am looking to have an Index Column that will repeat the same index number if the AccoutantLinkCode is repeated in another text field column.
So for the first AccountantLinkCode group "Bank" the index would be 1, then next group AR would be 2 and so on..
Can you advise the best approach or function to get this new index column in the table below?
Solved! Go to Solution.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.