Additional column 1 when append query

[ktt777]

Hi all, 

I want to append 3 queries as one. 

The results show additional column . For example column in original query is "Register Date" -> my append query will have both "Register Date" and "Register Date1" Columns . Anyone have this problem ? 

Does the columns need to be the same type to append ?

Thanks 

Thanks, 

[V-pazhen-msft]

@ktt777 

Can you reproduce this issue in a sample and share that pbix? It must I made some test with append but do not met this issue, usually the data type of the original columns do not have to be the same, the new column would change to "Any" type after append.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @ktt777 

I've run a test and different data types seem ok, pleases see the attached.

Have you checked if all the columns in all the tables have the same name?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[ktt777]

yes i has the same name. 

but even if it has different name, should it keep all the column with original name ? why does it add "1" to the column name ?

[Mariusz]

Hi @ktt777 

It's difficult to tell without seeing the data but investigating the difference between the table that adds the extra column and the rest is probably the key here.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

@ktt777 , Not very clear were you want to do it

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or you can create a common date dimension and join both dates to that.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/