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