Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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:
Import the dataset into Power BI.
Select the "Modeling" tab and then click on "New Table" to create a new table.
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.
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:
Import the dataset into Power BI.
Select the "Modeling" tab and then click on "New Table" to create a new table.
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.
can you share idea please
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.
Yes, you should be able to do this in one report.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |