Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PROBLEM: Waterfall chart with change value / Running Total

Hello, I am currently working on a waterfall chart. I only have the "change" values. So waterfall chart is not working. I tried to solve this with a running total which is not perfectly working, as i...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Sorry about that.

     

    Running Total = 
var d=max('Modell (2)'[DAY])
var c=max('Modell (2)'[Change])
var ov=sumx(filter(ALL('Modell (2)'),'Modell (2)'[Change]=c && 'Modell (2)'[DAY]<=d),'Modell (2)'[Values])
var tov=sumx(filter(ALL('Modell (2)'),'Modell (2)'[DAY]<=d),'Modell (2)'[Values])
return if(isfiltered('Modell (2)'[Change]),ov,tov)
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

No, that is not possible unless you want to do cross join acrobatics, or add fake 0 value transactions for the gaps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Alright. Still awesome that helps already a lot!