show current month over historical data

[jctorres]

Good afternoon, dear friends.

I'm looking for a way to implement the pre-invoices that will be charged in 2025 in my Dashboard, but show them as of the current date in my charts. For example, it's March 2024. So, in my charts, I can filter the measurements in the analysis set to the current month. However, I created a variable that contains this: Date(Addmonths(today(SCHEDULE_DATE),+1),'MM-YYYY')

Measure: sum({$<[MONTH_YEAR_NUM] = {'$(vCurrentDate)'},[Month_Year_Name]=,Month=>}TOTAL_AMOUNT)

The problem is that when I filter by any month other than the current one, it doesn't allow me to view the measurements in my charts.

Can someone tell me if this is possible or what function to add to my variable?

I attach an example of how I have the history of my information.

[Bhushan_Mahajan]

@jctorres Create your vCurrentDate variable based on ma scheduled date rather than today so if you select any date automatically t will work for that date as a max date.