Separate two different Values in a new row.

[Anonymous]

Spoiler

Hello , Please help me -- In Customer number/vms customer account coloumn there are 2 customer no. with a slash, I want these customer no. to be present in a new row with the same golden customer name . I could do this in source file but I have already loaded it and have made changes in model. Please assist.  

[amitchandak]

@Anonymous ,

You can split the column into rows in power query

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

If not you need use the dimension split

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[Anonymous]

Thankyou so much 🙏