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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ILANGO_10
Frequent Visitor

How add a value from last result with another column with condition

IMG_20230211_105510.jpg

 in this problem I need a needed column if seq no is 0 then add a previous value of needed with the value of quantity.. I hope you  can understand my problem... If you can't please see the picture there is Excel formula to got understand the problem... Please help me to find out the solution...

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-1676179951439.png

 

needed CC =
VAR _serialno = Data[serial no]
VAR _lastnonzeroseqnoserialno =
    MAXX (
        FILTER ( Data, Data[serial no] <= _serialno && Data[seq no] <> 0 ),
        Data[serial no]
    )
RETURN
    IF (
        Data[seq no] <> 0,
        Data[seq no],
        MAXX (
            FILTER ( Data, Data[serial no] = _lastnonzeroseqnoserialno ),
            Data[seq no]
        )
            + SUMX (
                FILTER (
                    Data,
                    Data[serial no] > _lastnonzeroseqnoserialno
                        && Data[serial no] <= _serialno
                ),
                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.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
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-1676179951439.png

 

needed CC =
VAR _serialno = Data[serial no]
VAR _lastnonzeroseqnoserialno =
    MAXX (
        FILTER ( Data, Data[serial no] <= _serialno && Data[seq no] <> 0 ),
        Data[serial no]
    )
RETURN
    IF (
        Data[seq no] <> 0,
        Data[seq no],
        MAXX (
            FILTER ( Data, Data[serial no] = _lastnonzeroseqnoserialno ),
            Data[seq no]
        )
            + SUMX (
                FILTER (
                    Data,
                    Data[serial no] > _lastnonzeroseqnoserialno
                        && Data[serial no] <= _serialno
                ),
                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.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.