Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create column retrieving specific value from another query

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.

 

 

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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