Excel like Formula editor in Power BI | Inforiver

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.

Inforiver brings advanced Power BI visuals, financial and variance analysis, and a no-code experience to Power BI for a seamless dashboard building experience. Get a 360-degree view of performance across multiple time periods and categories with automated variances, trend lines, and reference bands. Leverage features requested in Power BI idea place and community forums. Inforiver also enables easier comparison with external industry benchmarks. Automate your Excel processes with formula engine & calculations, manual data entry, forecasting, writeback, audit trail, commenting & collaboration. Inforiver delivers unique capabilities available in other BI & visualization software (such as Tableau, Spotfire, Qlik, Cognos and SAP BusinessObjects) but not in Power BI, so that organizations can successfully migrate and consolidate their BI assets with Power BI.

To receive regular updates visit:

#analytics