Planner Multiple Assigned Task Filter

Hi kaanbodur ,

There are a couple of ways to tackle this. 

i) you could use a formula to extract the names to a new columns.   To get the left most name use the formula =LEFT(E6,(FIND(";",E6,1)-1)), and the right name =RIGHT(E6,LEN(E6)-FIND(";",E6)) .  If you had 3 names then you would need to handle this differently. Ultimately I think that this soln is limited because you'd have to develop a formula to handle 3,4,5 names etc.

ii) Save the Excel file, and then use either Get Data from within Excel, or Get Data from within Power BI, and use the Split Column button in Power Query (in either Excel or Power BI) and split the column by the ";" delimiter.   IMHO this is the better solution as it will handle use case of different numbers of assignees.  This attached image should help a little bit.  You can also clean up the file by removing the top few rows, promoting headers etc...