urgent help required to join table in power bi

[vjnvinod]

Dear community,

i am looking for a help, i have 2 tables visuals in power, see below

i need to combine this together with one table, here is the attached sample file for your reference

https://www.dropbox.com/s/5br41pxhnk1ve0x/Test.pbix?dl=0

[v-piga-msft]

Hi @vjnvinod,

Based on your pbix file, If you want to achieve the output like append, I'm afraid that we may not join the table directly.

Here is a workaround, we could use UNION function to join the table. However, for your sceanrio, if we use UNION fucntion, the performance won't be well and it will show more rows. If your visual level filer is changed, you need to change the formula manully.

If you want to use UNION, you could refer to the formula below.

Table 3 =
UNION (
    SELECTCOLUMNS (
        FILTER (
            'Inbound',
            'Inbound'[HQArea] <> "Americas"
                && 'Inbound'[HQArea] <> "Asia-Pacific"
                && Inbound[HQArea] <> "EMEIA"
                && Inbound[HQArea] <> "Japan"
        ),
        "HQArea", 'Inbound'[HQArea],
        "TER_FYTD_USD", 'Inbound'[TER_FYTD_USD],
        "Growth.", [Growth.]
    ),
    SELECTCOLUMNS (
        FILTER (
            'Inbound',
            'Inbound'[Inbound] <> "Inbound from Americas"
                && 'Inbound'[Inbound] <> "Inbound from Asia-Pacific"
                && 'Inbound'[Inbound] <> "Inbound from EMEIA"
                && 'Inbound'[Inbound] <> "Inbound from Japan"
        ),
        "HQArea", 'Inbound'[DeliveryArea],
        "TER_FYTD_USD", 'Inbound'[TER_FYTD_USD],
        "Growth.", [Growth.]
    )
)

In another workaround, we could pin the two tables like below.

Best Regards,

Cherry

[vjnvinod]

@v-piga-msft

thanks for this, i think both solutions doesn't hold good.

In excel we could have done this very easily, unfortunately power BI is not helping to get there.

is there any alternative approach we can take to get their?

just wondering, something in power query, where some calcualte coloumns or some criteria to set this up?