Add earlier numbers in a column by date Power BI

[Nathan__Mox]

Hey all,

Is it possible to add up previous numbers in a column if they are at an earlier date by item code.

For example,

Item Code	date	Quantity	New Column
a	01/01/23	10	10
a	03/01/23	15	25
a	06/01/23	5	30
a	11/01/23	20	50
b	05/01/23	30	30
b	15/01/23	25	55

Hope this makes sense. Let me know if you need anymore information.

Thanks

Nathan

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Expected result CC =
SUMX (
    WINDOW (
        1,
        ABS,
        0,
        REL,
        SUMMARIZE ( Data, Data[Item Code], Data[date], Data[Quantity] ),
        ORDERBY ( Data[date], ASC ),
        KEEP,
        PARTITIONBY ( Data[Item Code] )
    ),
    Data[Quantity]
)

[Nathan__Mox]

That Worked!!

Thank you heaps