In order to set up our relationships in the Data Model, we need to create another table. This table is simply a list of all of the unique genres. We could base this query on our previous query called titleGenres. We’ll call our query Genres.

Here is what that query looks like in Power Query.

Create a new query by creating a Refernce to titleGenres. Rename it to Genres. Delete the tconst column. Remove Duplicates in the remaining Genre column as shown below in the screenshot.

For the data we are working with, and it’s only since the year 2000, we have 27 different genres. More than I expected.

Action, Adult, Adventure, Animation, Biography, Comedy, Crime, Documentary, Drama, Family, Fantasy, Game-Show, History, Horror, Music, Musical, Mystery, News, Reality-TV, Romance, Sci-Fi, Short, Sport, Talk-Show, Thriller, War, and Western.

Below is the Genres table in our relationship view (Diagram View) of Power Pivot.