Inforiver Videos
MatrixEnterprise
  • Writeback Matrix
    • Overview
      • Enterprise Planning & Performance Management in Power BI
      • Real-Integrated Planning in Power BI
      • Top 5 Driver-Based Planning Techniques in Power BI
      • Power BI Writeback - A deep dive
    • Features
      • Summary
      • Collaborative commenting
      • Schedule, burst & broadcast reports
      • Data writeback
      • Writeback to Fabric OneLake/Data Warehouse
      • Ad-hoc emails
      • Dropdown lists
  • Reporting Matrix
    • Expert speak
      • Visual formulas vs DAX with Marco Russo
      • Faster reporting and insights with Matt Allington
      • The best custom visual for Power BI?
      • Build a P&L / Income statement in less than 5 minutes
      • Formatting financial statements in Power BI - P&L
    • Overview
      • No-code reporting
      • Cutting-edge data visualizations
      • Advanced data analysis
      • Data provenance & audit
      • What-if simulations
    • General
      • Reorder rows and columns
      • Layout options
      • Advanced filtering
      • Nested top N + others
      • Conditional formatting
      • Number formatting
      • Cell & value formatting
      • Notes & annotations
      • Comments with filter context
      • Totals & subtotals
      • One-click templates
      • Pagination
      • Group rows and columns
      • Search & filter
      • Expand/collapse hierarchy
      • KPI explorer
      • Audit log
      • Export to Excel
      • Comparative measures
      • Images in columns
      • Ragged hierarchies
    • Formula & calculations
      • Excel-like cell editing
      • Insert calculated and static rows
      • Insert calculated column
      • Insert calculated measure
      • Quick formula options
      • Invert signs
    • Planning, budgeting & forecasting
      • Manual data input
      • Allocations
      • What-if simulations
      • Data entry & simulations in reading view
      • No-code rolling forecasts
    • Graphical tables
      • IBCS visualizations
      • Bar charts
      • Lollipop charts
      • Waterfall charts
      • Bullet charts for 2 measures
      • Bullet charts for 3 measures
      • Stacked charts
      • Sparkline charts
      • Tornado charts
      • KPI cards
      • Blend column
    • Conditional formatting
      • One-click options
      • Semantic formatting
      • Heat map formatting
      • Format entire row
      • Traffic light & arrow alert
      • Fill icon and star rating
      • Segmentation
      • Format top/bottom N rows
      • Branch level formatting
      • Conditional formatting of multiple hierarchies
      • Dynamic conditional formatting
      • Format using if conditions
    • Visual-level formulas
      • Excel-like cell editing
      • Quick formula options
      • Smart analysis
      • Excel-like formula editor
      • Calculated measures and columns
      • 4 ways of inserting rows
      • Evaluate columns before rows
      • Manage aggregations
      • Automatic variance calculations
  • Analytics+
Powered by GitBook
On this page
  1. Reporting Matrix
  2. Formula & calculations

Insert calculated and static rows

PreviousExcel-like cell editingNextInsert calculated column

Last updated 1 year ago

Inforiver delivers the fastest way to build reports in Microsoft Power BI. In this video, learn how to leverage Inforiver to

(a) Add static rows and enter values manually

(b) Insert calculated rows visually using an intuitive Excel-like editor

(c) Refer to the other rows using the formula section

(d) Use the total option to get the total of desired columns

(e) Use the include in charts option to visualize the data as a chart

(f) Leverage multiple formatting options for data within the report

(g) Insert % contribution rows in a single click

(h) Add template rows that repeat for categories/subcategories

Related resources

Feature highlights

User guide

Blog

Visual calculations in Power BI
Insert calculated rows
Insert manual input rows
Excel-like MoM, QoQ, YoY % calculations in rows in Power BI
Insert row and manually enter data in Power BI matrix reports