Taken by itself, NATURALINNERJOIN seems to work in the following definition: But the following UNION definition is currupted somehow: Suspect NATURALINNERJOIN to be the culprit. I'm usi...
v-qiuyu-msft
Community Support
Community SupportHi Dag,
With UNION() function, the column names in the return table will match the column names in table_expression1. From the second image, the return table will have the column name Spend rather than Cost.
By the way, to do join or union operations, you can do it in Query Editor which is more flexible ( http://radacad.com/append-vs-merge-in-power-bi-and-power-query ).
Best Regards,
Qiuyun Yu