Measure to calculate power

[leoxhc]

Hello, I need to create a measure that calculate the following expression: = (1 + 2%) ^ (BD / 252), where BD = Business Day. I have the following tables:

Table 1			table 2
Date	Business Day		Date	Symbol	Allocation	Type	Spread	Amount
01/01/19	0		01/05/2019	ABC	FI	Buy	2%	$10.000,00
01/02/19	1		01/09/2019	DEF	FI	Buy	3%	$   5.000,00
01/03/19	1
01/04/19	1
01/05/19	0
01/06/19	0
01/07/19	1
01/08/19	1
01/09/19	1
01/10/19	1
01/11/19	1
01/12/19	0
01/13/19	0
01/14/19	1
01/15/19	1

So, in this case, the measure called Current Amount must to sum + 1 to each column Spread, then power it the sum of column Business Day from day 01/05/19 for symbol ABC and 01/09/19 for symbol DEF through 01/15/19 , then divide this sum by 252 and when a matrix is filtered by Allocation the total amount of measure Current Amount must totalize the sum of current value, like shown below:

Symbol	Current Amount
ABC	$ 10.005,50
DEF	$   5.002,93

Allocation	Current Amount
FI	$ 15.008,44

The formula in excel spreadsheet is =(1+A3)^(SUM(B7:B17)/252)*I3

Thanks in advance.

[Greg_Deckler · Accepted solution]

So, as a column you could do something like:

Column = 
POWER(1 + [Spread], DIVIDE(SUMX(ALL('Table'),[Business Day]),252))*[Amount]