Creating Dynamic Parameters in Excel from link to Power Query

  1. Stefj
    Stefj
    Good Evening
    Any chance of someone in this group having experience with dynamic parameters. I am trying to use a Month End Date (Dynamic Date) to filter my Power Query (linked from SQL tables from Financial Software). I can hard code it each month but would like to simply enter the date in a table in Excel and it automatically updates my Reconciliation spreadsheets. I get as far as a A Submission Error Message due to the dynamic date field in power query not being in date format in the code relating to the Financial Software. I have watched Excellsfun Youtube channel Video 1349 but it uses Text fields as opposed to date fields. Any direction would be appreciated.

    Good night....
Results 1 to 1 of 1

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1