DAX To Split column into multiple rows

Dear all

I have a table in Power BI where it contains a created with DAX that displays the information separated by spaces.

E.g: #DOUBLE #REOPEN #MISSINGINFORMATION

Case Number	TAGS
A-123456789	#DOUBLE #REOPEN #MISSINGINFORMATION

What I want to create, is a new column that will split this information into multiple rows.

Like in this example:

However, this new column has to be done in DAX.

Would you please assist me?

Regards

Apr 21, 2021 in Power BI by Marcelo
• 120 points
edited Mar 4 • 26 views

No answer to this question. Be the first to respond.

Your name to display (optional):

Email me at this address if my answer is selected or commented on:

Privacy: Your email address will only be used for sending these notifications.

Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP