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

Calculate in Power BI

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
Calculate remaining budget in Power BI (without using DAX)
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

Looking for more?

Explore how you can tell compelling data stories

Continue

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver Logo
IBCS Certified
Power BI certified

About Inforiver!

Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 2,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.

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