Visual-level formulas
Excel-like cell editing (04:36)
Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells
Quick formula options (03:00)
Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group
Smart analysis (03:01)
Perform one-click contribution and variance analysis without using DAX
Excel-like formula editor (04:21)
Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers
Calculated measures and columns (02:31)
Add custom calculations as columns and measures without having to create new DAX measures or calculated columns in the data table
4 ways of inserting rows (06:09)
Insert static, calculated, contribution and template rows in Power BI
Evaluate column before rows (01:49)
Configure the column total and subtotal calculations when inserting calculated rows
Manage aggregations (4:00)
Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation
View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields
Last updated