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

[Anonymous]

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! 

[v-eqin-msft]

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

[v-eqin-msft]

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.

[amitchandak · Accepted 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

[Anonymous]

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