Combining Tables with identical fields

[janwillem]

I have 2 companies with the same table-columns.

Company A - Table "Company A - Purchase Line "

| Columns "Qty Purchase Line" - "Qty Received" - "Qty to Receive"  ->           No Company name in it.

Company B - Table "Company B - Purchase Line" | Columns "Qty Purchase Line" - "Qty Received" - "Qty to Receive"  ->             No Company name in it.

I will combine these 2 tables and filtering on Company:

Qty Purchase Line A+B;

Qty Received A+B;

Qty to Receive A+B.

            +

Slicer on Company

How can I do this?

[Zubair_Muhammad]

Hi @janwillem

You can create a new Calculated Table that combines these 2 tables and adds a column for Company Name

Go to Modelling Tab>>>NEW TABLE

New Table =
UNION (
    ADDCOLUMNS ( TableCompanyA, "Company Name", "Company A" ),
    ADDCOLUMNS ( TableCompanyB, "Company Name", "Company B" )
)