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

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
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