Forum Discussion

Wei_Pan's avatar
Wei_Pan
Frequent Visitor
1 year ago
Solved

how to use multiple parameters in power query to replace fixed value from SQL query

Hi I have used SQL query to bring two cycles (8+4 2024 cycle and 6+6 2024 cycle) of forecast data into power query. Due to the large size of data, I created two parameters in power query called "current_forecast_cycle" and "quarter_commit_cycle" which is supposed to be equivalent to the fixed value "8+4 2024 cycle" and "6+6 2024 cycle", so that I can change the parameter values in the power BI server side each time when new cycle forecast is available.

 

Since I have zero M code experience, I just copied some prior answers from this community, like below. But it won't return a correct answer.

 

Can anyone help to suggest how to properly use M code to replace the two fixed cycle value with the two paramters in power query advance editor?

 

Much appreicated in advance.

  • Wei_Pan's avatar
    Wei_Pan
    1 year ago

    Thank you lbendlin . I finally managed to guess out how this "& and &" works in such situation, and that works perfectly.

     

2 Replies

  • move the closing parenthesis before the last double quote

    • Wei_Pan's avatar
      Wei_Pan
      Frequent Visitor

      Thank you lbendlin . I finally managed to guess out how this "& and &" works in such situation, and that works perfectly.