Forum Discussion
Add a new Column in Power Query
Hi, this is my problem
I have 2 Tables "Ventas" and "Reuniones", and my goal is add a column (N° Reunion) in Ventas, i try with Merge Queries, the matching Column beetwen the 2 Tables is "Fecha", the parameter is unique in "Reuniones" and various in "Ventas", but the result at Expand the Merge Queries is only "null",
what it´s wrong? or exist another form to do that?
Regards
While merging select Fecha column join column (This you already know)
Prefer Left Outer same as I did, then expand desired columns
Result will be as below
Let me know if you need sample pbix file
Regards,
Arvind
4 Replies
While merging select Fecha column join column (This you already know)
Prefer Left Outer same as I did, then expand desired columns
Result will be as below
Let me know if you need sample pbix file
Regards,
Arvind
Hi andrescaso,
The way as arvindsingh802 shared should worked well. Could you please share your sample data if that doesn't make sense?
Regards,
Frank
Thanks
The solution work for me,
