Forum Discussion
Solved
Help with filter and multiple instances
I use a system that generates an excel report we run through PowerBI that has a 'Team' column. For projects where one team is responsible that individual team name is displayed e.g. Durham Th...
Hi,
In the Query Editor, you should right click on the Teams column and select Split Column > By delimiter. Select | as the seperator and under Advanced, select Split by rows.
Hope this helps.
Hi,
In the Query Editor, you should right click on the Teams column and select Split Column > By delimiter. Select | as the seperator and under Advanced, select Split by rows.
Hope this helps.
Amazing, thank you so much!
You are welcome.
