Reference Cell/table value for a parameter value in power query RRS feed

  • Question

  • Hi,

    I have a SQL Server query set up in my Excel 2016 file that has @BeginDate and @EndDate in it.  I set up a pivot table that will run this query and return results.  I want to be able to have cell values above the pivot table that has Begin and End Dates that a user enters who can then refresh the pivot table which will then use these values to rerun the query and refresh the results.  I read through some posts and set up a table called TableBeginDate and TableEndDate.  As an example, the TableBeginDate table is in cells BI and B2 with B1 being "Begin Date" and B2 being the date the use enters.  TableEndDate is in cells D1 and D2 with D1 being the "End Date" header and D2 being the end date the user enters. How do I get values from B2 and D2 to become my @BeginDate and @EndDate values in my query?


    Monday, September 10, 2018 3:40 PM


All replies