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
nabu
Frequent Visitor

Get Previous Increase in Value When 2 Contracts Match

Hello,

 

I have a list of contracts that get a new tag after every renewal. I want to find the % increase that resulted in the new contract price. That output is to be stored in the Prev % Inc column. To get the output, I check when column D (old contract) and column E (new contract) are equal. When these two are equal, the result value in column H should be the % Increase value (highlighted in red) associated with column E (the new contract column) OR contract where the Contract Status is "EXPIRED".

 

Thank you in advance for your help

 

INPUT:

nabu_3-1657062785343.png

 

OUTPUT:

nabu_6-1657062871437.png

 

 

 

 

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a calculated column.

 

Untitled.png

 

Previous percent increase CC = 
VAR _contractold = Data[Contract No Old]
RETURN
    SUMMARIZE (
        FILTER (
            Data,
            Data[Contract Status] = "Expired"
                && Data[Contract No New] = _contractold
        ),
        Data[Percent increase]
    )

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

2 REPLIES 2
nabu
Frequent Visitor

Your solustion answers my question perfectly. Thank you!

Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a calculated column.

 

Untitled.png

 

Previous percent increase CC = 
VAR _contractold = Data[Contract No Old]
RETURN
    SUMMARIZE (
        FILTER (
            Data,
            Data[Contract Status] = "Expired"
                && Data[Contract No New] = _contractold
        ),
        Data[Percent increase]
    )

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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