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.
Hi all - From the below, I have a contract value that repeats for 1 contract which is its original vlaue. I want the "Column" to take the original Contract total minus the invoice amount to show as getting smaller and smaller after each invoice.
So the first line in the "column" column would be $142,576 minus the $2,084.85 giving me the $140,491.15. Then the next line would start with the $140,491.15 and subtract the next invoice $3,817.44. Currently, it is just taking the Original contract amount, "Contract Total" and subtracting every invoice but not as a running total. This seems alot more complicated than originally though due to the amount of posts on this. Appreciate any help ASAP. Thank you!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
https://drive.google.com/file/d/1HD-EKoByAP6y76SOOQ0591x5g0gRf9To/view?usp=drivesdk
hi - I just had to make a simple version of my secure data. As mentioned. I just want a column that takes the original contract amount (which is static) minus each invoice. But I want the contract amount to get smaller as each invoice is paid. So my first line should be $150,000 minus invoice 1 for 100,000. Than the next line would start with $100,000 and so on.
access is denied - please check
Hi Ibendlin- It looks like I cannot share because of the company protection on the file. The data I used is simple. The real source data is much more complex but the general gist is to have the contract amount decrease as invoice is paid in its own column. Thanks for trying.
You say you want the remaining invoice amount to decrease yet in your expected result it is increasing?
I tried granting access another way.https://drive.google.com/file/d/1rZuznBfi4YxOekxLjkFCFTdCLBHzTBTs/view?usp=drivesdk
Hi - Yes sorry that was jsut for the example, So what I want it to do is have the invoice amount subtract from the contract amount. But I want the new value in the "amount remainging to start the next row. So create a running total only getting less in amount.
So I would have $150,000 - 50,000 and then have the next line start as $100,000 instead of 150,000 again then subtract that from the next invoice -50,000 and so on until there is not amoutn to be invoiced left.S So I would have a decreasing new contract amount.
Contract AMount | New Contract Amount | invoice amount | invoice amoutn remaining | |||
150,000 | 50,000 | 100,000 | ||||
100,000 | 50,000 | 50,000 | ||||
50,000 | 50,000 | 0 |
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |