FILTER OR A MEASURE

[kunal_mehta1]

Hello All,
The dataset attached below is a sample of the data i have.
There are projects which has financials and date of submission . I am making a visual which would show the amount of financials required in total, based on the date. I want a filter or measure which would show the financials only from todays date and max future date available in that column. I have a column chart visual where i have months on x axis and financials on y axis.

[wdx223_Daniel · Accepted solution]

FinTotal = CALCULATE(SUM(SampleData[financials]),KEEPFILTERS('Calendar'[Date]>=TODAY()))

[kunal_mehta1]

Thanks Daniel. You are amazing!!