Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

cumulative line chart

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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.

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.