Forum Discussion
Create Dimension table from multiple tables
Hi, How do I create a dimension table from multiple (i.e. different) tables? And is DAX or Power Query more preferable? Or both? (Please don't ask me to give a data example, because the quest...
Anonymous
I take it the reason you need to create a dimension table from different tables is that not one of the tables contains the complete set of values you need as your lookup table, right? (If not, then just in Power Query create a new query referencing the table containing the whole range of values and then create the relevant relationships to the fact tables)
I would do it in Power Query using the append function to add all the necessary tables, removing unwanted columns, and removing duplicates from the main field etc...
What if there is no table having the whole range of values??