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

[Anonymous]

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 B column 2.

Current incorrect formula is: = [column 1]/#"Query B"

Any assistance appreciated. Wondering if it is possible without merging.

[v-easonf-msft · Accepted solution]

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]

@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])