Using Offest by the day

[GJeanes1]

Hello all!

So every day I have to click Filters --> Filters on this page and select what day it is, so today I checked the box for October 5th. 

I have day/month filters so that we can see the number of incidents within a year-to-date timeframe, as you see it ignores the year and looks at the month and day, while my matrix visual includes the year so it encompasses all of it.

Is there a better and less tedious way to accomplish this? Such as a day-by-day offset?

Any help is greatly appreciated!

[GJeanes1]

I have been researching how to have an offset calendar and have rolling totals, however, my issue is I am looking at an automated rolling total for the current year and for previous years,

So if today is 10/10/23, then the code would read total data for this year between 1/1/2023 to today, then look for last year's data between 1/1/2022 up to today's date last year (10/10/22),

I also need the dates to be automated for previous years so that when tomorrow comes, the previous year's data would look at "today (10/11/23)" so I am not manually clicking which day it is.

Then continue looking at those dates and years back to 2018

Please let me know how to accomplish this.

[GJeanes1]

so here is my issue, this is what I have now in order to have this visual I have a matrix, with year, number of issues, and YTD change, below is the filter for the page that uses a day/month that i have extracted from the number of issues (middle column).

This is a newer visual with the same filters except the day/month filter. this issue is getting the visual to look at the day automatically, while the visual can look at the year in order to see the correct numbers. (I don't know if that is the best way for PBI to read what I'm trying to do).

[samdthompson]

Hello, you can do it with all sorts of DAX'ing and columns or you can just apply a filter which generally will work for most historic solutions. if you have a forecasty future based calendar it might be a be easier to make a DAX based solution with rolling days but i suspect this will be the most straight foward solution for what youve described:

Cheers,