Forum Discussion
Helper IRunning value with no dates
Hi all-
I am trying to get a running value for my table between two columns but adding the rows. Most examples always have dates. I only need to combine the running value between the two more muliple contract and contract amendments.
Example
Contract Amendments | Amended Amount | contract total | Running total | ||
| Contract A | 1 | 0 | 200000 | 200000 | |
| Contract A | 2 | 50000 | 200000 | 250000 | |
| 3 | 10000 | 250000 | 260000 |
Thanks Philip - is there any work-around for single value cannot be determined.
Hi edavis248
Your parentheses are in the wrong place, the first SELECTEDVALUE isnt closed. Try this
Measure 10 = SELECTEDVALUE(Merge2[ASB Original Contract Amount]) + SELECTEDVALUE(Merge2[CONTR_AMD_VALUE])Regards
Phil
5 Replies
- PhilipTreacy
Super User
Hi edavis248
As a measure:
Total = SELECTEDVALUE('DataTable'[Amended]) + SELECTEDVALUE('DataTable'[Amount Contract])Regards
Phil
edavis248Thanks Philip - is there any work-around for single value cannot be determined.
- PhilipTreacy
Hi edavis248
Your parentheses are in the wrong place, the first SELECTEDVALUE isnt closed. Try this
Measure 10 = SELECTEDVALUE(Merge2[ASB Original Contract Amount]) + SELECTEDVALUE(Merge2[CONTR_AMD_VALUE])Regards
Phil
- edavis248
Also I guess my question is how to get the total in amount contract ot build on itself. I dont have that field in the data. So I would need 200000 plus the 50000 to be added inthe amount contract row as 250000.
- PhilipTreacy
hi edavis248
You can't change the value in the Amount Contract Total, you have to create another column or measure to hold that total value of Contract Amount + Amended, which is the Total I created.
Regards
Phil