Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'Data'[Undiscounted Value] / (1+'Discount Rate'[Discount Rate Value])^([Component]/12)
- IF(TODAY() > LASTDATE('Data'[Date]), BLANK(),
- DATEDIFF(TODAY(), LASTDATE('Data'[Date]), MONTH))
- SUM ('Data'[Undiscounted Value] ) / (1+'Discount Rate'[Discount Rate Value])^(MAX(Component) /12)
Add Comment
Please, Sign In to add comment