Forum Discussion

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
3 years ago

Running total only shows final value accross dates

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.