Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
27 | |
21 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |