https://whatthefact.bi/power-bi/dax/combine-multiple-tables-with-union-union-all-in-sql-server-append-in-power-query-or-union-in-dax/
Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX