Forum Discussion

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago
Solved

create chart that accumulates values over date

hello everyone here i have an example of my table: Date                      Value 12/22/2022           -1 12/23/2022 3 12/27/2022 -9 12/28/2022 8 12/29/2022 2 12/30/2022...
  • adudani's avatar
    adudani
    3 years ago

    HI

    thanks for clarifying

     

    have updated this file: https://1drv.ms/u/s!AkGuKJKxOlnAeqVqsn2-BsSfKWM?e=n2BZNW

     

    this is the measure:

     

    cumulative total =

    VAR LastVisibleDate =
        MAX ( 'Table'[Dates] )
    VAR FirstVisibleDate =
        MIN ( 'Table'[Dates] )
    VAR LastDateWithSales =
        CALCULATE (
            MAX ( 'Table'[Dates] ),
            REMOVEFILTERS ()  -- Use ALL ( Sales ) if REMOVEFILTERS () and ALL ()
                               -- are not available
        )
    VAR Result =
        IF (
            FirstVisibleDate <= LastDateWithSales,
            CALCULATE (
                [value],
               'Table'[Dates] <= LastVisibleDate
            )
        )
    RETURN
        Result
     
     
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi eliasayyy ,

    I have created a simple sample, please refer to my pbix file to see if it helps you.

    Create a measure.

    Measure = VAR _MAX=MAXX(ALLSELECTED('Table'),'Table'[DATE])
VAR _MIN=MINX(ALLSELECTED('Table'),'Table'[DATE])
RETURN
CALCULATE(SUM('Table'[VALUE]),FILTER(ALL('Table'),'Table'[DATE]<=SELECTEDVALUE('Table'[DATE])&&'Table'[DATE]>=_MIN&&'Table'[DATE]<=_MAX))

    The value would change by the date.

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

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

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

hello adudani i already have this metric thank you but i want an accumulted value of the sum so for example the sum of values on dec 22 was -1 then on dec 23 the number was 3 and in dec 27 value was -9 so in theory the graph value should show
dec 22 = -1
dec 23 = 2
dec 27 = -7

adudani's avatar
adudani
Icon for Memorable Member rankMemorable Member
3 years ago

HI

thanks for clarifying

 

have updated this file: https://1drv.ms/u/s!AkGuKJKxOlnAeqVqsn2-BsSfKWM?e=n2BZNW

 

this is the measure:

 

cumulative total =

VAR LastVisibleDate =
    MAX ( 'Table'[Dates] )
VAR FirstVisibleDate =
    MIN ( 'Table'[Dates] )
VAR LastDateWithSales =
    CALCULATE (
        MAX ( 'Table'[Dates] ),
        REMOVEFILTERS ()  -- Use ALL ( Sales ) if REMOVEFILTERS () and ALL ()
                           -- are not available
    )
VAR Result =
    IF (
        FirstVisibleDate <= LastDateWithSales,
        CALCULATE (
            [value],
           'Table'[Dates] <= LastVisibleDate
        )
    )
RETURN
    Result