Forum Discussion
Helper IPopulate column based on similar text in another column
Solution SageHello orana ,
If the account names are going to be static then you can use grouping activity in Power BI Desktop and create second column. Then if you want ranking you have to create any numeric column for reference or else you can also use alphabetical order for the same.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Helper IHey Kishore_KVN
If I understand your comment correctly - there is a grouping function that allows me to group accounts. Would you happen to know if this grouping function is automated? I have about 31,000 account names, and manually grouping accounts would take a lot of time.
RE: Ranking - I'm not trying to rank the account names. The column example output 2 is another way to group the account names. I can group them numerically or by text.