convert a Column ( with has multiple values separated by commas into a list.

[krishnachaitany]

Hi Everyone,

                    I am working on Personal Project on Power BI on the Dataset used for 'Highest Hollywood Grossing Movies' and need ideas/assistance on this following Query in Power Query or DAX . Can anyone provide your valuable ideas on this.

QUERY:- Need to convert a Column (Genre Attribute) with has multiple values separated by commas into a list. So, that I can make a unique Dimension Table , use it as a slicer and also for also making data model by creating a Star Schema.

Example for Reference:-Movie " Titanic (1997) " in the dataset falls under multiple Genres ( Drama, Romance ) which are stored in a single Column 'Genre'.I am looking for solution where it can split this into 2 rows containing information alike

Titanic (1997) - Drama.

Titanic (1997)-Romance.

Please verify the Image for clear understanding of Dataset.

[krishnachaitany]

Thanks 😊@Greg_Deckler .It is working and my met my requirement.Please find the screenshots for reference.

[Greg_Deckler · Accepted solution]

@krishnachaitany Use Text.Split