-
Notifications
You must be signed in to change notification settings - Fork 23
Most used functions
Izabela Elzbieta Buczynska edited this page Jun 23, 2020
·
1 revision
CAGR(beginningValue, endingValue, years)
Calculates compound annual growth rate.
YoY(pastValue, presentValue)
Calculates year-over-year growth.
IF(condition, trueValue, falseValue)
Works like the Excel IF function.
A complete list of all supported functions can be found here:
https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/blob/master/docs/Calculations.md
- Home
- Security
- Getting started
- Adding data to the visual
- Title
- Column styling
- Row expansion
- Row and Column totals
- Column expansion
- Values options
- Custom subtotals - rows
- Row styles - appearance
- Hiding rows
- Hiding columns
- Hide empty rows
- Formatting
- Custom columns
- Overriding column calculations
- Ragged hierarchies
- Web URL
- Applied steps
- Data Bars
- Export to Excel
- Thousand and Decimal Separator
- Measure Placement
- Calculations
- Theming
- Find Visual Version