Date Filters / "This Year" on Jan 1

[ExcelAtEverything]

Helo,
When using Date Filters in a Power Query to be used in a Pivot Table (a Pivot Table which will always show monthly totals, I selected the date filter "This Year", which works fine for me right now. But I started thinking, what about on January 1? The correct data that I need will be filtered out before it hits the Pivot Table. I suppose I could just not use that filter at all, but then I'm thinking I'll end up seeing 2 January columns. I have Index and vlookup formulas referencing the month names in that table, so that will cause problems. How can I avoid this? Thx

 

[ranman256]

there's only 1 january for the current year. Why would you get 2 januarys?

 

[ExcelAtEverything]

Hi Ranman256Because as it stands with the "this year" date filter, the query will pull the info from this 2021's months. But if I wake up on January 1 and go to run the numbers and get all the final reporting for 2021 (including the final December monthly report which will then include the final day of December 31st), won't the "this year" filter on (Jan 1) then filter out 2021. Beacause at that point, 2021 is not "this year", 2022 is. So I was saying, that's why I stopped and turned that "this year" date filter off. BUT, it also seems to me that turning off the year-related filter would result in there soon being 2 Januarys (2021 & 2022, then 2 Februarys, etc. Is that right? or no? Thanks!