I am able to query my four tables into four querys that contain the single column that I need, however I am struggling to UNION these Querys.

I have created a new table using the union DAX but I assuming that this is now a static table and will not be updated?

If it will be updated then I have my solution!

If not I need to union these into a query via power query.

All advice is gratfully received.

---------------------------------------------------------------------------

Ideally I would like to be able to Union ([Table1,Column1],[Table2,Column4],[Table3,Column1], [Table4,Column10]) (excuse the syntax) this is easily possible in Access and would save building the edited querys down to one column in addition to the data being always "live".