Forum Discussion

andrescaso's avatar
andrescaso
Resolver I
7 years ago
Solved

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",...
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

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's avatar
andrescaso
Resolver I
7 years ago

Thanks

 

The solution work for me,