Forum Discussion
Running 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
Hi edavis248
As a measure:
Total = SELECTEDVALUE('DataTable'[Amended]) + SELECTEDVALUE('DataTable'[Amount Contract])Regards
Phil
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
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.
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