Measure to calculate power

Question

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&nbsp;&nbsp;table 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DateBusiness Day&nbsp;DateSymbolAllocationTypeSpreadAmount01/01/190&nbsp;01/05/2019ABCFIBuy2%$10.000,0001/02/191&nbsp;01/09/2019DEFFIBuy3%$ &nbsp; 5.000,0001/03/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/04/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/05/190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/06/190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/07/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/08/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/09/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/10/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/11/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/12/190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/13/190&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/14/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01/15/191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;So, in this case, the measure called&nbsp;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 ,&nbsp;then divide&nbsp;this sum by 252 and when a matrix is filtered by Allocation the total amount of measure&nbsp;Current Amount must totalize the sum of current value, like shown below:SymbolCurrent AmountABC&nbsp;$ 10.005,50DEF&nbsp;$&nbsp;&nbsp; 5.002,93&nbsp;AllocationCurrent AmountFI&nbsp;$ 15.008,44&nbsp;The formula in excel spreadsheet is&nbsp;=(1+A3)^(SUM(B7:B17)/252)*I3&nbsp;Thanks in advance.

greg_deckler · Accepted Answer

So, as a column you could do something like:
&nbsp;
&nbsp;
Column = 
POWER(1 + [Spread], DIVIDE(SUMX(ALL('Table'),[Business Day]),252))*[Amount]

Forum Discussion

Measure to calculate power

1 Reply

Related content

DAX Calculated Measure

power bi measure

POWER BI DAX MEASURE

Measure or Calculated Column

DAX Measure for Ranking the valid rows and calculating the average rating

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

Allocation	Current Amount
FI	$ 15.008,44