Adding data rows to a TABEL (= merging data of two tables)

[FlyHigh]

Hello, 

I have a table created of a query and added of some cols.

is it possible to add some rows to this table (not in the query editor) or merging two tables with the same structure to a new one ?

Im using PowerBI Desktop.

best regards 

Peter

[v-yulgu-msft · Accepted solution]

Hi @FlyHigh,

To add some rows to a table, you can use UNION function to combine two tables into a single one.

Currently, it is not available to merge tables directly using DAX (not in the query editor). But as a workaround, we can first CROSSJOIN two tables, then use FILTER to get our desired rows.

Best regards,
Yuliana Gu