Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
)
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.
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]
)
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.