Forum Discussion

Raj2410's avatar
Raj2410
Helper I
3 years ago

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

  • 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:

    1. Open Power BI Desktop and go to the "Home" tab.
    2. Click on "Combine" in the "Transform Data" group and select "Merge Queries".
    3. 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".
    4. Next, select the column in both tables that contains the unique value and ensure they are the same data type.
    5. Under the "Join Kind" option, select "Left Outer (all from first, matching from second)".
    6. 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.