Forum Discussion

Bart-ek's avatar
Bart-ek
Icon for Helper I rankHelper I
6 years ago
Solved

cumulative values without any time frame with separated lines for legend

I want to accumulate values over time without any time frame. I have visual created with single line but I can't make separate values for separate groups to be shown on the same chart (without creati...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Bart-ek ,

     

    try this

     

    cumulation of results = 
VAR MaxDate = MAX('CALENDAR'[Date])
RETURN
  CALCULATE(
    SUM(test[result in numbers]),
    FILTER(
      ALL(CALENDAR),
      'CALENDAR'[Date] <= MaxDate
    )
  )

     

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

  • Bart-ek's avatar
    Bart-ek
    6 years ago

    actually found a solution myself too after I've placed this thread 😄 ... 

     

    all('CALENDAR')
    instead of 
    all('test')
     
    that brings this result:
Bart-ek's avatar
Bart-ek
Icon for Helper I rankHelper I
6 years ago

actually found a solution myself too after I've placed this thread 😄 ... 

 

all('CALENDAR')
instead of 
all('test')
 
that brings this result:
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Bart-ek ,

 

Please mark a post as solution, this will help others.