Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
Solved! Go to Solution.
@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
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
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:
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.
@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
They're both calculated tables so I can't merge them, but I'm now trying to bypass the issue.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.