New year data not populating into Query

[Anonymous]

With the new year, we are looking to add 2023 monthly data into my query but unfortunately, it is not populating. All of the CSV has the correct updated data, but when I export my file I don't see Jan-23. Below is a screenshot of what I see when it comes to my filter. Any suggestions are welcomed!

[AlexisOlson]

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.

[Anonymous]

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.

[AlexisOlson · Accepted solution]

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.