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 fr...
  • v-juanli-msft's avatar
    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.