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 "curr...
Need Help
  • 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.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

move the closing parenthesis before the last double quote

  • Wei_Pan's avatar
    Wei_Pan
    Frequent Visitor
    1 year ago

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