Forum Discussion

gadao's avatar
gadao
Frequent Visitor
4 years ago
Solved

Use Parameter as Query Reference in Source

I have query (query 1) that performs a lot of steps to correct the dataset, I load it to excel and then I loaded it back to PQ, Now I use this query (query_1) to perform other corrections, which give...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, gadao 

    You can try the following solution:

    1. create a custom fuction SwitchQuery:

    (query as table)=>
let 
source = query
in source

    2. Invoked fuction:

    let
    Source = SwitchQuery(Query2)
in
    Source

     2. for the Main table:

    let
    Source = #"Invoked Function"
in
    Source

    You only need to change the query of the invoked function to change the query of the main table at any time.

     Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, gadao 

You can try the following solution:

1. create a custom fuction SwitchQuery:

(query as table)=>
let 
source = query
in source

2. Invoked fuction:

let
    Source = SwitchQuery(Query2)
in
    Source

 2. for the Main table:

let
    Source = #"Invoked Function"
in
    Source

You only need to change the query of the invoked function to change the query of the main table at any time.

 Result:

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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