Back

Results

Add a Formula measure

If you have spent years writing formulas across cell ranges in a spreadsheet, this episode is the reset. We add Product Selling Price from the semantic model, then create a formula measure called Units Actual - Revenue Actual divided by Product Selling Price - set as a visual measure with Sum on the column and formula execution on every row. The point is the engine: you select measure objects, not ranges or arrays, and one expression fills the whole grid, grand total included.

Read More

Request a demo

Learn how Lumel helps enterprises deliver real-time integrated reporting and planning applications

Get Lumel Brochure

Enhance your BI, analytics and xP&A use cases with our no-code Data App suite for Power BI.
Download now

Request a demo

Learn how Lumel helps enterprises deliver real-time integrated reporting and planning applications

Get Lumel Brochure

Enhance your BI, analytics and xP&A use cases with our no-code Data App suite for Power BI.
Download now
Lumel
Look Forward. Think Ahead ®
Leader in Unified Planning & Analytics for the Modern Data Stack.
© Lumel Inc. All rights reserved.
Connect With Us
Headquarters
5920 Windhaven Pkwy,
Plano TX 75093
United States