Forum Discussion
Raj2410
3 years agoHelper I
undefined
One table has unique value and other table has multiple dates for the unique value how to bring the multiple value to one coloumn in a new table
1 Reply
- EstebanSimoesNew Member
Try this:
To bring multiple values from one table to a new table in Power BI, you can use the "Merge Queries" feature. Here's how you can do it:
- Open Power BI Desktop and go to the "Home" tab.
- Click on "Combine" in the "Transform Data" group and select "Merge Queries".
- In the "Merge Queries" dialog box, select the table that has the unique value as the "Primary Table" and the table that has multiple dates as the "Related Table".
- Next, select the column in both tables that contains the unique value and ensure they are the same data type.
- Under the "Join Kind" option, select "Left Outer (all from first, matching from second)".
- Finally, select the column(s) from the related table that you want to bring into the new table and click OK.
This will create a new table with the unique value and the related dates brought together into a single column.