The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
OUTPUT:
Solved! Go to Solution.
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.
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]
)
Your solustion answers my question perfectly. Thank you!
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.
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]
)
User | Count |
---|---|
13 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |