cancel
Showing results for
Did you mean:
New Member

## Running totals of future date

Hello guys, I need some help.

I have some data of my company investments. That data is divided in columns like "Date Position, Value (\$), Release Date".

Date position = it shows the investments value that are active on the day selected.

Value = amount of money

Release Date = the date that I can retrieve that amount without paying any taxes.

I'm created a visual that, after I select the date position (like 8th june), it shows the amount of money that I can retrieve after that date without paying any taxes. The dates here go from june 8th june (date position) to 28th june (last release date)

But I'm trying to create a measure that it shows the running totals until the last "release date" (28th june, in the example) that is set, normally (not a rule), 30 days after my position date.

I tried looking for forums and videos, but every single running total's tutorial talks about past days until the selected date.

Thanks!

1 ACCEPTED SOLUTION
Community Support

Hi @ThorP ,

Try this

Measure = CALCULATE(SUM('APLICATIONS'[Value]),FILTER(ALLSELECTED(APLICATIONS),[Release Date]<=MAX('APLICATIONS'[Release Date])))

I don’t know if my results are correct. If so, can you explain how your curve is obtained? For example, the date of June 17th, what value does it add up?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

Hi @ThorP ,

The easiest measure is like

CALCULATE(SUM(VALUE), FILTER(ALL(TABLE), [DATE]<=[THE LAST RELEASE DATE]&&[DATE]>=[THE LAST RELEASE DATE]-29)

Without dummy data and expected results, it is difficult for me to give the correct formula. If possible, please provide.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

New Member

Hello Stephen!

Here's some dummy data and my expected result is to create a visual with my release value over the release dates and the running totals like this example:

Sample

Community Support

Hi @ThorP ,

Try this

Measure = CALCULATE(SUM('APLICATIONS'[Value]),FILTER(ALLSELECTED(APLICATIONS),[Release Date]<=MAX('APLICATIONS'[Release Date])))

I don’t know if my results are correct. If so, can you explain how your curve is obtained? For example, the date of June 17th, what value does it add up?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User III

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors