Join multiple different tables

[Anonymous]

Hello,

I have loaded 6 tables in power bi. Combination of date and email would act as unique identifier for each table. I want to merge all 6 tables based on date and email to create sort of one super table, then use that super table for my visualisation.

I need to update these tables on weekly basis, so could you suggest me what to do here. Is there a way to do it in a clean way.

Thanks

Jitendra

[parry2k]

@Anonymous you can use append features in power query to make super table. There are many blog on how to combine multiple files from a folder. Hope this video help.

[Anonymous]

@parry2k  Thanks for the reply. I think I didn't put my question properly. I am looking for something like merge query (want to join 6 tables in one go).

Isn't append is for putting row data one below other? I want to column merge them. I have read somewhere that you can do that in one go in sql, don't know how to do that in power bi. I tried joining them one by one using full outer join but that seems lees intuitive.

Updating later on is no problem at the moment as I will manually update them in excel and refresh it in power bi. I hope that won't be problem.

I am new to power bi.

Thanks

Jitendra

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at links below. 

• https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
• https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/