Help With Multiple sheets and Drop downs

[jesfree13]

Hello, 

I have a strange one. I have a sheet (Sheet A, I cannot change this one). Then I have anther sheet (Sheet B, I can edit this one) that has a few selections on it that I would like to create a "Table" in Power BI using a field in List A then having selections whcih I can pick from on the table from List B. For Example of the table I want to have Power BI make for me:

Book (From Sheet A)	Reading Status (From Sheet B)	Series Type (From Sheet)
Book 1	On Hold	On Going
Book 2	Reading	One Book
Book 3	On Hold	Mini Series
Book 4	Abandoned	One Book
Book 5	Just Collecting	On Going
Book 6	Reading	Mini Series

So to try to better expalin, I export a list of my books from a site and it gives me an excel sheet .xlxs that I just wan to put into a folder. Also in the folder I have a excel sheet I made with 3 cloumns one for series type, one for reading status, and a third I will use later. Is there a way to do this. Basically make a table in BI where I can have my list from sheet A and added cloumns where I can select things from sheet B? Thank you for any help.

[v-weiyan1-msft]

Hi @jesfree13 ,

From your description, it should be possible to infer that there is a relationship between the two tables.

I think you could try joining the two tables together using a merge query.

The operation is shown below:

In Power Query Editor, select Merge queries.

From here，choose to expand the fields in the new table column.

Result is as below.

My Sample:

TableA:

TableB:

If you want to know more about the Merge queries, you can refer to the following link.

Merge queries overview - Power Query | Microsoft Learn

Best Regards,

Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.