Issue with append queries

[SamiaSouissi]

Hello,

I attempted to append two queries that share the same columns, intending to add rows of data from the second table to the first. However, I encountered an issue with the date column. Power Query created a new column named 'date' and added the new data to it separately, instead of appending it to the existing column. I have verified the names and formats of the two columns, and have tried multiple times, but the result remains the same: two separate columns instead of a single one with appended data.

Have you any ideas please ?

[peruloganathan]

Ihave created a power bi report , in which i have appended sales data of individual months from Jan 24 to Aug 24 using append queries option in tab. But while running a report iam getting double entry of billed Quantity in only Aug 24 selection of date. Kindly give solution to this problem

[SamiaSouissi]

Oui, c'était ça le problème, merci beacoup !

[slorin · Accepted solution]

Bonjour @SamiaSouissi 

N'y a t'il pas un espace après le mot "Date" ?

Stéphane