Forum Discussion
Solved
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 ...
So, as a column you could do something like:
Column = POWER(1 + [Spread], DIVIDE(SUMX(ALL('Table'),[Business Day]),252))*[Amount]
Greg_Deckler
Community Champion
Community ChampionSo, as a column you could do something like:
Column =
POWER(1 + [Spread], DIVIDE(SUMX(ALL('Table'),[Business Day]),252))*[Amount]