Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

New year data not populating into Query

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!

 

KSiler_0-1675364006640.png

 

1 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.

View solution in original post

3 REPLIES 3
AlexisOlson
Super User
Super User

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
Not applicable

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.

 

KSiler_0-1675370658979.png

 

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.