same repoort with different join(merge) in same dataset

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.