cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Measure to calculate power

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

1 ACCEPTED SOLUTION
Super User

So, as a column you could do something like:

```Column =

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Super User

So, as a column you could do something like:

```Column =

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.