Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query Editor Custom Column - Divide column from query by column from another query

There are 2 queries: Query A, which contains column 1 Query B, which contains column 2   In Power Query Editor for Query A, I wish to create a custom column that divides Query A column 1 by Query...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    You can try to use List Functions  in Power Query without using a query merge to do lookups in Power Query.

    If you have an index column in QueryB, you can add custom columns as below:
    [Position in QueryB]

    List.PositionOf(QueryB[Index],[ID])

    [Column2]

    QueryB[Column2]{[Position in QueryB]}

    Result:

    [Column1]/[Column2]

    Please check my sample pbix file for more details.

     

    Best Regards,
    Community Support Team _ Eason

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , If you do not merge you can not get line by line

 

Usually, you can get a column from another table Query B[Column2], But this is a list

 

So you might have to do List.Sum(Query B[Column2])