Running total only shows final value accross dates

[SebSchoon1]

Hello Guys,

i use this formula

1-RT STOCK pas mal 2 = 

VAR _selecteddate = SELECTEDVALUE('4- Calendrier période n'[Date])

VAR _datemax = CALCULATE(MAX('4- Calendrier période n'[Date]), ALL ('BDD - Lignes de mouvements'))

RETURN

IF( _selecteddate> _datemax,BLANK(),CALCULATE('1-Mesures sur mouvements de stock'[Test aggregation stock],ALL('4- Calendrier période n'[Date]),'4- Calendrier période n'[Date] <= _selecteddate))

However when i used it with another date field than ==> '4- Calendrier période n'[Date] into my visual

it only shows the final value of the calculation, which is 4 and this on each row of the visual.

if i use '4- Calendrier période n'[Date]  it runs out of memory even in i use slicers to show only one item.

Any help?

i'm struggling with these running totals for ages now.

I have 12million rows and many warehouses, it is a real pain to find something working well.

[Padycosmos]

I hope this video helps:

https://www.youtube.com/watch?v=y7ucCjtADsg

[amitchandak]

@SebSchoon1 , Try new window function, that should do a better job

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc