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...
Dag
Advocate II
Advocate IIHi v-qiuyu-msft,
Thanks for taking an interest. I'm afraid the problem is more severe than you suggest; all columns are shuffled such that there is no connection between column heading and content.
The first column contains strings "ClientName" in both tables of the UNION. The last column contains dates "RunDay" in both tables of the UNION. The middle column contains amounts "Cost" or "spend" in the respective tables of the UNION. The two pictures of table definitions and views captures the whole story.
I use UNION frequently. Never had a problem, and out of the blue Power BI is shuffeling column names around. Therefore, I suspect NATURALINNERJOIN.
Best,
Dag