Forum Discussion
Help With Multiple sheets and Drop downs
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.
1 Reply
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.
