Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

I need to add a column of data which would result in additional rows - how do I do this?

I've got two tables:

Products: product name, ticket type, product ID and ticket ID

Events: product name, product id and session name

 

I want to append the product table to include the session name. This will require the addition of extra rows, as each product can have multiple sessions.

 

Any suggestions on how I can go about this?

 

Thanks! 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , You can join both tables in the product id and display them together, in visual

 

of you can use concatenateX(Products[Product id], Events[session name],",") to display in same line

 

or you can merge these tables in power query https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @Anonymous ,

 

Could you tell me if my post helps you ? If so, please kindly Accept it as the solution  to make the thread closed. More people will benefit from it.

 

Hope to hear from you😀

 

Best Regards,
Eyelyn Qin

Anonymous
Not applicable

Hi @Anonymous ,

 

You could use NATURALLEFTOUTERJOIN() to create a new table:

New Table =
VAR _t1 =
    SELECTCOLUMNS (
        'Products(cal_table)',
        "pid", [product ID] & "",
        "pname", [product name] & "",
        "tid", [ticket ID],
        "ttype", [ticket type]
    )
VAR _t2 =
    SELECTCOLUMNS (
        'Events(cal_table)',
        "pid", [product ID] & "",
        "pname", [product name] & "",
        "sname", [session name]
    )
RETURN
    NATURALLEFTOUTERJOIN ( _t1, _t2 )

The final output is shown below:

NATURALLEFTOUTERJOIN.PNG

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , You can join both tables in the product id and display them together, in visual

 

of you can use concatenateX(Products[Product id], Events[session name],",") to display in same line

 

or you can merge these tables in power query https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

They're both calculated tables so I can't merge them, but I'm now trying to bypass the issue.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.