I am trying to map 2 queries in power bi desktop

[Anonymous]

Hi, 

I have 2 queries - Query1 and Query2. I need to use the column from query2 as an input to query1. Can we do it in Power BI? If so, can someone please let me know how?

[v-yuta-msft · Accepted solution]

@Anonymous ,

Yes, you can refer to another query in advanced editor, please check out demo below:

Query1:

let
    Source = Table.FromRecords({[Key = 1, Value = 2]}),
    Result = Table.Combine({Source, 
                            Table.RenameColumns(
                            Table.SelectColumns(Query2, {"Key", "Value"}), 
                            {{"Key", "Key From Query2"}, {"Value", "Value From Query2"}})})
in
    Result

Query2:

let
    Source = Table.FromRecords({[Key = 2, Value = 3]})
in
    Source

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.