Add a new Column in Power Query

[andrescaso]

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

[v-frfei-msft]

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

[andrescaso]

Thanks

The solution work for me, 

[arvindsingh802 · Accepted solution]

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

[Anonymous]

Can you post some sample data here to understand the issue better?

Thanks
Raj