Excel-like formula editor

Inforiver provides a no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers. The formula editor provides syntax, examples and features such as autocomplete, multi-line support and more to help users create, and troubleshoot formulas.

(a) Conditional statements - IF, IFNA and SWITCH

(b) Logical functions - AND, NOT, OR, IN, ISEMPTY etc.

(c) Math functions - ABS, AVERAGE, AVERAGEIF, COUNT, SUM, FILTER etc.

(d) Text formatting functions - CONCATENATE, LEFT, RIGHT, MID, CLEAN, UPPER, LOWER etc.

(e) Date functions - DAY, MONTH, DATEADD, DATEDIFF, FROMEXCELDATE, TOEXCELDATE etc.

(f) Statistical functions - MEDIAN, MODE, QUARTILE, QUARTILEEXC, STDEV, STDEVP etc.

(g) Sort functions – SORT, SORTDESC

(h) Identifiers - COLUMNS, DESCENDANTS, HAS, HAS_ALL, RELATIVE etc.

Related resources

Feature highlights

Visual calculations in Power BI

User guide

Insert calculated rows

Insert calculated columns

List of formulas and functions

Blog

Excel-like MoM, QoQ, YoY % calculations in rows in Power BI

Insert calculated measure or column in Power BI