cumulative line chart

[Anonymous]

hello All,

need your help, i tried to make an cumulative line as you can see down here. my problem is my formulas sum up all the past quantity and i would like to sum only for 2019 .

cumulative line = CALCULATE(SUM('BDD MPS'[Qty Delivered]);FILTER(ALL('BDD MPS');And('BDD MPS'[GR date th].[Year]=2019;'BDD MPS'[Month GR Date TH]<=MAX('BDD MPS'[Month GR Date TH]))))

the graph

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please try to use this one.

a =
IF (
    YEAR ( MAX ( 'BDD MPS'[GR date th] ) ) = 2019;
    CALCULATE (
        SUM ( 'BDD MPS'[Qty Delivered] );
        FILTER (
            ALL ( 'BDD MPS' );
            'BDD MPS'[Month GR Date TH] <= MAX ( 'BDD MPS'[Month GR Date TH] )
        )
    );
    BLANK ()
)

If it doesn't meet your requirement, Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.