NATURALINNERJOIN not workning

Hi 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

Hi 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

Hi Dag,

Would you please share the pbix file file if possible? 

Best Regards,
Qiuyun Yu

Hi v-qiuyu-msft,

I am able and willing to reproduce the error, but not OK with sharing client data publicly. 

Sincerely,

Dag

Hi Dag,

You can upload the pbix file to your Onedrive and share the link in private message, is it fine? 

Best Regards,
Qiuyun Yu