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.
I created a measure that finds the delta between two values, as shown below,
Line | CME Budget | Amount Billed | Est To Comp | Est At Comp | CME Delta |
1 | $5,248,197.27 | $116,608 | $6,675 | $123,283 | $ 5,124,914.57 |
2 | $1,098,000 | $224,264 | $321,876 | $546,140 | $ 1,649,859.74 |
3 | $671,106.57 | $0 | $34,157 | $34,157 | $ 636,949.62 |
4 | $599,000 | $0 | $48,792 | $48,792 | $ 550,208.02 |
@Keyla2020 , Try like
SUM('Milestone Data'[CME Budget])-sum(ABS('ad (2)'[EAC]))
or
SUM('Milestone Data'[CME Budget])-ABS(sum('ad (2)'[EAC]))
Hi @Keyla2020
The column 'CME Budget' and 'EAC' in the screen shot doesn't look like a number column. As the number column will be right aligned as in the last column 'CME Delta'.
Can you confirm the columns used in the calculation are number, if not convert them to number and try the formula.
If they are number column try using the below formula instead with an ABS for SUM().
CME Delta = ABS(SUM('Milestone Data'[CME Budget]))-ABS('ad (2)'[EAC])
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @Keyla2020 ,
Your issue is not very clear to me. Would you please show us some more details? You may try the following measure:
CME Delta = SUM('Milestone Data'[CME Budget])-ABS(SUM('ad (2)'[EAC]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
This is complicated to explain in words, due to this Power BI dashboard being a rats nest. I wish I could share my screen and we can walk through it. Is there a measure I can use to overwrite the output?
Meaning, I want to manually input CME Delta value for those two projects.
Hi @Keyla2020 ,
I really can’t understand the output you want, please explain your needs in detail otherwise it will be difficult for us to help you.
Best Regards,
Dedmon Dai
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |