Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Issue with append queries

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 ?

 

 

 

  • Bonjour Anonymous 

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

    Stéphane 

3 Replies

  • Bonjour Anonymous 

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

    Stéphane 

  • Anonymous's avatar
    Anonymous
    Not applicable

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

  • 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