4. Adding business logic and formulae

We successfully used filters, KPI explorer, manage columns, expand/collapse hierarchies, group & pin rows and columns, and many other features in the previous section. In this section, we'll cover the following:

1. Insert calculated rows - Inforiver provides an option to insert calculated rows using an Excel-like formula engine. To learn more, refer to insert calculated rows.

2. Insert calculated columns - With Inforiver, it is possible to insert a new calculated column or measure at the visual level. To learn more, refer to insert calculated columns.

3. Insert manual input rows - Inforiver allows you to insert static rows in matrix-style reports where you can input or enter the data. To learn more, refer to insert manual input rows.

4. Insert manual input columns - Inforiver provides six (6) different options to manually enter data in your Power BI report such as date, text, single/multi-select etc. To learn more, refer to insert manual input columns.

5. Invert sign - Using the invert sign feature you can change the signs for cells or rows right within the report. To learn more, refer to Invert sign.

6. Editing cells - Edit native measures and apply calculations at visual level. Learn more about editing cells.

7. Quick formula - Inforiver provides several one-click calculations for inserting columns and rows. To learn more, refer to quick formulas.

8. Manage inserted rows & columns - Rows or columns inserted in the visual such as calculations, static rows, or data input columns can be managed using the 'Manage' options. To learn more, refer to Manage inserted rows & columns.

9. Insert image URLs - Rows or columns inserted in the visual such as calculations, static rows, or data input columns can be

Resources

Visual calculations using Inforiver

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

Calculate remaining budget without using DAX

Implement SUM measure totals without using DAX