Forum Discussion
dshah12
Helper II
3 years agoAssign Short Names for large titles
I have some of the large titles like -> Ahmeda boxing champion trust Rocking - ABCTR And they are probably around 20 and this field is used as filter almost everywhere so I want to assign short...
Nathaniel_C
Community Champion
3 years agoHi dshah12 ,
If I understand what you are trying to do, please go to Power Query and create a conditional column in your table.
It would be something like this: If naming column = blah blah blah, then bbb. Then your short names stay the same, and only the long ones would change. Or if what you are showing is after the dash "ABCTR" what you want to show, you can split the column by the dash.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel