Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help Merge 3 Tables 3 Column

Hi,   The requirement is, i have 3 tables with 3 different columns and now i have to use those 3 columns in a new measure i am unable to merge those 3 columns getting data as null and merging is n...
  • v-yadongf-msft's avatar
    4 years ago

    Hi Anonymous ,

     

    If you do not matcing columns and want to combine columns, try adding an index column to each table in Power Query as shown below:

     

    Then you can merge by index column:

     

    At last, you can merge 3 tables 3 columns:

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.