Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

The fastest way to

create visual calculations

in Power BI

Inforiver writeback

Flexible formula editor

Define visual-level formulae using logical, math, text functions and more

Cell-level formulae

Use spreadsheet-like formula bar to edit cell value or define formula; supports formula references to other cells

Insert rows, columns & measures

Manually type in values or calculate using the formula editor

Quick formula options

One-click options to insert columns such as % contribution to grand total, running total, ranking within group

Custom total aggregations

Define aggregations for totals and subtotals at the visual-level without using DAX

Conditional functions

Leverage functions such as if, else, switch to define conditional statements

Boolean functions

Define boolean expressions using functions such as and, or, xor, and not

Lead/lag functions

Shift any trend data by 'n' periods using lead/lag functions

String functions

Manipulate text using string functions such as concatenate, left, match

Featured Blogs

Excel-like MoM, QoQ, YoY % Calculations in Rows in Power BI
Implement SUM measure totals in Power BI (without using DAX)

Highlights

1. Flexible formula editor

Leverage 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

Flexible formula editor

2. Cell-level formulae

Use spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells

Cell-level formulae

3. Insert rows, columns & measures​

Insert static rows and columns where you can manually type in values (supports scaled entries) or define calculations using the formula editor. Calculations can also be inserted for every column hierarchy using visual measures

Insert rows, columns & measures
Insert rows, columns & measures

4. Quick formula options​

Inforiver provides one-click options to insert columns and measures such as % contribution to grand total, running total, ranking within group. % contribution and variance columns can also be inserted based on a cell selection

Quick formula options​
Quick formula options​

5. Custom total aggregation​

Define aggregations for totals and subtotals at the visual-level without using DAX. Inforiver provides aggregation types such as sum, average, minimum, maximum, average, visible rounding etc. out-of-the-box

Custom total aggregation

6. Conditional functions

Leverage functions such as IF, ELSE, SWITCH to define conditional statements 

Conditional functions ​

7. Boolean functions

Define boolean expressions using functions such as AND, OR, XOR, and NOT

Boolean functions

8. Lead/lag functions ​

Shift any trend data by 'n' periods using lead/lag functions and quickly perform variance calculations such as QoQ growth, YoY growth etc

Lead/lag functions ​

9. String functions

Manipulate text using string functions such as CONCATENATE, LEFT, MATCH ​

String functions
Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram