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

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

Your answer

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.