Merge or append 2 queries (in direct query mode)

[Anonymous]

Hello,

I would like to combine some data from 2 differents tables in direct query mode.

The objective is to get sales from table 2 to table 1, for only 1 specific shop (see example below).

I tried Amend function but not working in direct query mode. 

And merge doesn't seems my solution since in reality, my tables headers are different.

Do you have any other suggestion? 

Thank you!

Example :

example

[supsinha_pbi]

Even Union in DAX create table in import mode. I need the resultant table to be in direct query mode only  @v-jiascu-msft

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Do you have the latest version of Power BI Desktop? You can append the queries in the Query Editor after changing the column names. 

Another solution is using DAX. Maybe this one like below.

Table =
UNION (
    SELECTCOLUMNS (
        st2,
        "Date", [Date],
        "Day", [Dayz],
        "Month", [Month],
        "Value", [Value],
        "Year", [Year]
    ),
    SELECTCOLUMNS (
        table2,
        "Date", [date2],
        "Day", [Dayz],
        "Month", [Month],
        "Value", [Value],
        "Year", [year2]
    )
)
  

Best Regards,

[Anonymous]

hello @v-jiascu-msft,

Thanks for your advice, I will use it accordingly (in DAX).