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

[Wei_Pan]

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.

[lbendlin]

move the closing parenthesis before the last double quote

[Wei_Pan · Accepted solution]

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