Hi, I need to create a button, a formula, a macro that modifies an SQL query in Power Query.
Query calculate date from day to day. Each time I have to enter the query and change the end date (marked in red).
Is it possible in Excel to enter the date in a cell and then enter a button that will update the query?
makro.jpg
You can create a parameter table to use in PQ:
https://support.microsoft.com/en-us/...0-b205a69e0f33
"M is for Data Monkey" by Puls and Escobar covers it in detail, too.
Bernie Deitrick
Excel MVP 2000-2010
You need to concatenate it into the SQL:
,'" & EndDate & "'))#
etc
Everyone who confuses correlation and causation ends up dead.
Back to the topic. I need help
I still have some syntax error.
error.jpg
If EndDate is a number, not text, you'll need to wrap it in Text.From to be able to concatenate it:
Please Login or Register to view this content.
Thank you very much.
Now I can change a parameter in 20 queries with one click
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks