Forum Discussion
New year data not populating into Query
Scroll up to the top of the applied steps. I'm guessing there are a couple of steps/parameters that define the date range with hardcoded values. You can update these to suit your needs.
If you don't want hardcoded values that you need to update every year, it's possible to determine a date range from the data you load in. I often do something like
[...] StartDate = #date(Date.Year(List.Min(Data[Date])), 1, 1), EndDate = #date(Date.Year(List.Max(Data[Date])), 12, 31), [...]This goes from the start of the year of the minimal date to the end of the year on the maximal date from the Data table.
I can't tell just from the screenshot.
- Check for any date filters or date parameters in your queries.
- Check how your date table is defined. Is it set to go through a fixed date?
- Check your report page slicers and filter panes for stray filtering.
So what I notice is that our calendar file hasn't been updated since Feb 2022, does anyone know an easier way than manually updating this query? I am still fairly new to the program and don't know much about it.
Scroll up to the top of the applied steps. I'm guessing there are a couple of steps/parameters that define the date range with hardcoded values. You can update these to suit your needs.
If you don't want hardcoded values that you need to update every year, it's possible to determine a date range from the data you load in. I often do something like
[...] StartDate = #date(Date.Year(List.Min(Data[Date])), 1, 1), EndDate = #date(Date.Year(List.Max(Data[Date])), 12, 31), [...]This goes from the start of the year of the minimal date to the end of the year on the maximal date from the Data table.