Forum Discussion

hvlfc's avatar
hvlfc
Frequent Visitor
4 years ago
Solved

Cumalative column starting on specific Date

Hi all,   I need to add a cumalative column, but it should only start to acumalate on the 16th of february.   My initial table looks like this:     I need to create a column that sees 16...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi hvlfc ,

     

    Please try this:-

    Column =
CALCULATE (
    SUM ( [Product] ),
    FILTER (
        ALL ( StockSummary ),
        [date] <= EARLIER ( StockSummary[Date] )
            && [Date] >= DATE ( 2022, 2, 16 )
    )
)

    Output:-

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi hvlfc ,

 

Please try this:-

Column =
CALCULATE (
    SUM ( [Product] ),
    FILTER (
        ALL ( StockSummary ),
        [date] <= EARLIER ( StockSummary[Date] )
            && [Date] >= DATE ( 2022, 2, 16 )
    )
)

Output:-

 

Thanks,

Samarth

  • hvlfc's avatar
    hvlfc
    Frequent Visitor
    4 years ago

    Thank you Samarth_18 ,

     

    That works!

     

    Is it possible to calculate backwards from the 16th? i.e

     

     

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      4 years ago

      hvlfc , Try this:-

      Column =
CALCULATE (
    SUM ( [Product] ),
    FILTER (
        ALL ( StockSummary ),
        [date] >= EARLIER ( StockSummary[Date] )
            && [Date] <= DATE ( 2022, 2, 16 )
    )
)

      Output:-