I have trouble creating a reference / mapping table using the Power Query Editor. I'm trying to create a reference / mapping table from two different data tables that have no relationship to one another.
The goal is to use this reference table for allowing the Slicer to slice the data for the two data tables at the same time.
Table1 Data: Apple Oranges Peaches Watermelon
Table2 Data: Aappple Cider Oorrange Peel Ppeeach Puree Wwaatermelon Juice
I want to create a separate reference table: Column 1 | Column 2 Apple | Aappple Cider Orange | Oorrange Peel Peach | Ppeeach Puree Watermelon | Wwaatermelon Juice
There is no logic to automatically match the two data tables, so I was hoping to reach out to community and see if a reference table from the two preexisting tables can be created within the Power Query Editor.
My alternative is to manually maintain a mapping table outside of Power BI but I don’t want to maintain another external table from an extra data table.