Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nathan__Mox
Helper I
Helper I

Add earlier numbers in a column by date Power BI

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 CodedateQuantityNew Column
a01/01/231010
a03/01/231525
a06/01/23530
a11/01/232050
b05/01/233030
b15/01/232555

 

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

 

Thanks

Nathan

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

Jihwan_Kim_0-1674362231434.png

 

 

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]
)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

Jihwan_Kim_0-1674362231434.png

 

 

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]
)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


That Worked!!

 

Thank you heaps

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.