same repoort with different join(merge) in same dataset

[mmh]

Hi,

I have one report where dataset need to to merge two ways, ie. left join with  one column  and another join with same datset, same tables but within 3 columns. is it posible to make it within one report or need to generate two report.

Thanks

MMH

[Adamboer · Accepted solution]

Yes, it is possible to merge two ways within one report. You can achieve this by using Power BI's merging and joining capabilities.

Here are the steps you can follow to merge the dataset in two ways:

1. Import the dataset into Power BI.

2. Select the "Modeling" tab and then click on "New Table" to create a new table.

3. In the formula bar, enter the formula for left join with one column. For example, if you want to left join Table1 with Table2 on the "ID" column, the formula would be:
   
   LeftJoinTable = LEFT JOIN(Table1, Table2, "ID")
   
   Create another new table, and in the formula bar, enter the formula for the second join. For example, if you want to inner join Table2 with Table1 on the columns "ID", "Date", and "Product", the formula would be:
   
   InnerJoinTable = INNER JOIN(Table2, Table1, {"ID", "Date", "Product"})
   
   

   By following these steps, you should be able to merge your dataset in two ways within one report.

   You can now use the "LeftJoinTable" and "InnerJoinTable" in your report as needed.

[mmh]

can you share idea please

[Ehren]

In addition to what Adamboer suggested, you can also do this in Power Query if you'd like to do the joins before loading to the model.

• Start with your two queries (Table1 and Table2) in the Power Query Editor
• Select Table1, and then from the Home ribbon choose Merge -> Merge Queries as New
• Enter the settings for your first join and click OK
• Select Table1 and once again click Merge Queries as New
• Enter the settings for your second join and click OK

[Ehren]

Yes, you should be able to do this in one report.