Forum Discussion
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.
Thank you lbendlin . I finally managed to guess out how this "& and &" works in such situation, and that works perfectly.