Query Parameter not updating form Query List

I just ran into this.  Basically you want a "parameter" (little p), not a "Parameter". Avoid using the Parameters menu altogether. I take it that is for suggesting values to change manually at some point on the service, not being truly dynamic and automatic.

Instead take your query that creates the "parameter" and right click the value and hit drill down. This will give you a dynamic value that will update on refresh.

You can reference this in a formula step elsewhere or in the advanced editor without first hitting manage parameters. 

In my case I had a date table and I wanted a start date and and end date dynamic parameter to filter the date table, which would be different everyday.

And then I just apply a filter on my DimDate table using that (and a 2nd parameter I made):

= Table.SelectRows(DimDate1, each [Cal_Date_DT] >= WoWDate and [Cal_Date_DT] <= LastBusDate)