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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.