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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KSiler
New Member

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors