Create column retrieving specific value from another query

[Anonymous]

I have two queries - Query A and Query B.

In Query A, I am trying to create a custom column whereby if Column A (which is within Query A) = 1, then the result should be an exact specific value from the table produced in Query B. 

I would expect there is a very straightforward solution for this, but as I'm still relatively new to Power BI I'm struggling to work out the formula to retrieve a specific value from a different query.

Thanks.

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is there any relationship between two tables?

If there is no relationship, for example, get the first value from "table B" into "Table A" where [cola]=1

In Power query, add a custom column

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.