Forum Discussion
Solved
Get Parameter from SQL Query - then pass that Parameter into a different SQL Query
I'm sucessfully passing a Parameter into my Power Query SQL statements. An example of the M code to reference a Parameter: p.CreateDateUTC >= '"&StartDT&"' And the parameter itself: ...
Usually you need a format like YYYY-MM-DD, but get it working with a hard-code value and then reproduce that using Date.ToText( ), if needed. Then you just reference the query name, not the step name. In your case,
pCreateDateUTC<" & RevEndDt
If there is more after that, you can concatenate that with & "rest of sql expression"
Regards,
Pat
Instead of using a parameter, you can have the output of a query to be a text value. Use your first parameter in a query, create the text string you need, and then use that query instead of the parameter instead of the 2nd parameter.
Regards,
Pat