Look Who it Was Random video

Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc

4,670 views · Published 20 May 2017 · 12:14 · Indexed 31 October 2026

Channel: excelisfun · 2017 · Education

Watch on YouTube

Download File:
Start File: https://excelisfun.net/files/EMT1427Start.xlsx
Finished File: https://excelisfun.net/files/EMT1427Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
See how to use GEOMEANX and other DAX Formulas to calculate the Average Counpounding Rate per Period and a Future Value Calculation. Topics:
1. (00:13) Introduction
2. (01:09) Data Model Setup
3. (02:27) GEOMEANX DAX function to calculate Average Compounding Rate per Period.
4. (04:40) How DAX Formula Calculate on Filtered Tables
5. (05:19) COUNTROWS DAX function to count Number of Years for each investment
6. (05:55) What Happens When I Accidentally Drag a Table Column (Field) to Values Area of PivotTable and inadvertently create an Implicit Measure. See how to “Show Implicit Measures” and then Delete Implicit Formula.
7. (06:58) MIN DAX function to calculate the First Year of Investment
8. (07:29) DAX Formula to calculate Future Value of Initial Investment to get Current Investment Value for each type of investment
9. (09:48) Amend Formula so it does not show Grand Total Row with IF and HASONEVALUE DAX Function.
10. (11:29) ) Summary

More from this channel