vbaisdaxing
New Member
- Joined
- Aug 23, 2017
- Messages
- 12
Date | Amounts | Compounded Data |
1/1/17 | 1 | |
1/2/17 | 2 | |
1/3/17 | 3 | |
1/4/17 | 4 | 8 |
1/5/17 | 5 | 8.8 |
1/6/17 | 6 | 9.68 |
1/7/17 | 7 | 10.648 |
1/8/17 | 8 | 11.7128 |
1/9/17 | 9 | |
1/10/17 | 10 | |
<tbody>
</tbody>
Hello Everyone,
Here is what I am trying to accomplish. First, I have named the table above as tblData. Based on the data table above, I would like to be able to select the dates of 1/4-1/8 through a slicer and have the following occur:
1. On the first date selected, multiply by the first date selected by 2; 4 x 2 = 8
2. for every other date selected, the previous entry will then be compounded by an interest rate of 10%; for example, 1/5/17 = 8 *(1+.10) and 1/6/17= 8.8 * ( 1+.10)
I know one way to start solving the problem is to utilize a Cumulative total DAX formula which I have succesfully utuilzied below.
SelectedCumulativeTotal:=CALCULATE(SUM(tblData[amounts]),FILTER(ALLSELECTED(tblData[date]),tblData[date]<=MAX(tblData[date])))
I'm just having trouble with the last two conditions I'm trying to accomplish.
Any suggestions/help would be greatly appreciated.
Thank you very much.