Power BI Desktop Tips and Tricks (10/100) - How to Join tables in Power BI Merge

[@irfandaud7380]

Way of explaining stuff is really good..

[@AnalyticswithNags]

Thanks

[@rahulgautam511]

Hello Nags, Which is more performance efficient Joins or Relationships?

[@AnalyticswithNags]

Different Joins not meant for performance. Each join has its purpose.

[@bpradeepkumar2435]

Hi Sir your use the data for demo purposes this data is where available can you share a link

[@AnalyticswithNags]

Check the description of the video

[@pvnp007]

Sir, I have two tables (direct query) I need to merge those two tables as single table, is it possible to do with full outer join. Two tables are from direct query mode

[@AnalyticswithNags]

Try it. If it is from same source you can do it. If it is not allowing in power BI, join in source itself in a view and use the view

[@nagarjunach115]

Hi.. here I have two datasets with the same data column names. Like prod and test (datsets). I have to create a report for these two datasets.. as prod vs test. Need some inputs.

[@AnalyticswithNags]

Create a column named source In each table , that should contain prod , test respectively. Then you need to append the data. Not the join/ merge. Then you can analyse both data

[@sanc7753]

Hi sir I have query how to i creare view or resident load in power bi..what I need Perform inner join on two tables Then map result of this query with left outer join with another query . Next from all above result take calculated columns as table How can I do this in power bi

[@AnalyticswithNags]

I hope your question itself has the answer. Follow the steps you have drafted you will get the results. After inner join two tables you get new table . And the left join new table with another table. From this comupte the calculated column.

[@sanc7753]

Oh thanks for your quick response ...I will try if any query I will come back to you ..its ok na?

[@AnalyticswithNags]

ok sure

[@sitbackandrelax2482]

nice video good keep doing

[@AnalyticswithNags]

Thank you, we will, Keep learning and share with your friends.