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
Automatic variance calculations (1:44)	View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields