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...
Hi Anonymous ,
If the two tables have one same column but have different value such as ID, we can create a calculated table:
IDTable =
UNION (
DISTINCT ( 'Table A'[ID] ),
DISTINCT ( 'Table B'[ID] )
)
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.