Forum Discussion

krishnachaitany's avatar
krishnachaitany
Frequent Visitor
3 years ago
Solved

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

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.