We will merge the customer id and customer name column in the Power Query editor. In this task, you import products from the Products and Orders.xlsx (downloaded and renamed above) file into an Excel workbook, promote rows to column headers, remove some columns, and load the query to a worksheet. I am using two tables i.e. How can I do this? If you want all rows from table1 that does not exist in table2, then you can write as below; The result would be all rows that only exist in table1. The returned table has lineage where possible. Select the Sales query, and then select Merge queries. Power BI helps to get easy visualization for you. Combine columns from different tables to make one table Power BI DAX Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and so on. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. I've tried Table.NestedJoin (Table1,Table2) but I get errors. In this step, you create a Custom Column to calculate the line total for each Order_Details row. Tutorial: Shape and combine data in Power BI Desktop Load each table into Power Query as a separate query fix up the column names as needed for each individual query save each query as a connection in one of the queries (or in a separate query) use the Append command to append all the fixed up queries that now have the same column names. In this article, you will learn about joins of Two Tables in Power BI. Example The following DAX query: DAX EVALUATE DISTINCT ( SELECTCOLUMNS ( Date, "Month", COMBINEVALUES ( ", ", [MonthName], [CalendarYear] ) ) ) Returns the following single column table: In order to perform this tutorial, you need the Productsworkbook. Next, perform the same selections in the Countries table. http://services.odata.org/Northwind/Northwind.svc.