Forum Discussion
Solved
External Mapping for data mashup
Hi, I am looking for a functionality in Power BI where I can externally map the multiple attributes to staging table attributes. There are multiple data sources with different structure and attri...
varunaggarwal30,
You can use DAX to create a new table, there is an example for your reference.NewTable = UNION(SELECTCOLUMNS(Stage,"col1",Stage[Column1],"col2",Stage[Column2],"col3",Stage[Column3]),SELECTCOLUMNS(sheet1,"col1",sheet1[Alias],"col2",sheet1[Column3],"col3",sheet1[id]),SELECTCOLUMNS(Report,"col1",Report[name],"col2",Report[Column10],"col3",Report[column1]))
Regards,
Lydia
varunaggarwal30,
You can use DAX to create a new table, there is an example for your reference.
NewTable = UNION(SELECTCOLUMNS(Stage,"col1",Stage[Column1],"col2",Stage[Column2],"col3",Stage[Column3]),SELECTCOLUMNS(sheet1,"col1",sheet1[Alias],"col2",sheet1[Column3],"col3",sheet1[id]),SELECTCOLUMNS(Report,"col1",Report[name],"col2",Report[Column10],"col3",Report[column1]))
Regards,
Lydia
Anonymous,
Is there any way we can have different column numbers and can add new columns from different sources. I tried add column option but it says union should have sam column
For Workaround I gave same columns in the all tables and kept them empty for non source table. Is there any cleaner way to do this?
varunaggarwal30,
When using Union function, column number should be same from different tables.
Regards,
Lydia