I have office 365 excel version:
So, I have the parameter table working for the Region & Department columns but the Period column date range is not updating if I change the start date criteria or the end date criteria.
Attempted fixes:
make sure the Period column is type Date
make sure the PeriodStart and PeriodEnd are type Date
I have entered dates that diminish the problem of different locales - startDate = 5/5/2016 endDate 7/7/2016
the Budget table has 252 rows of 2016 data
Deleted all the parameters then recreated them twice - all of them are connections
My Query output is Sheet 1 - have the Data & Parameters tab as well
My file is attached - I am sending you the file without the data validation as I don't think it would have affected the date result.
I opened the completed file for this and yours worked however it changed the date values to serial numbers!
Hi Dianne,
You stopped one step too soon. You simply need to add another filter for the Period field:
= Table.SelectRows(#"Filtered Rows1", each ([Period] >= ParameterPeriodStart and [Period] <= ParameterPeriodEnd))
In your Applied Steps pane you should have 3 Filtered Rows steps, you only have 2. Hope that helps.
Mynda
