// Saudi Aramco · Power BI measures (example practice data). Paste each into New measure.
// Tables: Sales (fact), Date, Product, Region.

Revenue = SUM(Sales[Revenue])

Profit = SUM(Sales[Profit])

Barrels = SUM(Sales[Qty])

Margin % = DIVIDE([Profit], [Revenue])

Revenue 2026 = CALCULATE([Revenue], 'Date'[Year] = 2026)

Revenue 2025 = CALCULATE([Revenue], 'Date'[Year] = 2025)

YoY % = DIVIDE([Revenue 2026] - [Revenue 2025], [Revenue 2025])

Discount % = DIVIDE(SUM(Sales[Discount]), SUM(Sales[GrossSales]))

Revenue per barrel = DIVIDE([Revenue], [Barrels])

Cost per barrel = DIVIDE(SUM(Sales[Cost]), [Barrels])

Crude % = DIVIDE(CALCULATE([Barrels], Sales[ProductType] = "Crude"), [Barrels])

Export % = DIVIDE(CALCULATE([Barrels], Sales[Export] = "Yes"), [Barrels])

Asia % = DIVIDE(CALCULATE([Barrels], Sales[Region] = "Asia"), [Barrels])

Term % = DIVIDE(CALCULATE([Barrels], Sales[Channel] = "Term contract"), [Barrels])

Gross Sales = SUM(Sales[GrossSales])

Discount Amt = SUM(Sales[Discount])

Cost = SUM(Sales[Cost])

Revenue PY = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Date'[Date]))

ΔPY = [Revenue 2026] - [Revenue 2025]

ΔPY % = DIVIDE([ΔPY], [Revenue 2025])

Contribution % = DIVIDE([ΔPY], CALCULATE([ΔPY], ALL(Sales[Product])))

Margin % 2026 = DIVIDE(CALCULATE([Profit], 'Date'[Year] = 2026), [Revenue 2026])

Revenue MA3 = DIVIDE(CALCULATE([Revenue], DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -3, MONTH)), 3)

Price Change = 0.03

Discount Change = -0.10

Cost Change = 0.02

Volume Change = -0.01

WhatIf Revenue = (CALCULATE([Gross Sales], 'Date'[Year] = 2026) * (1 + [Price Change]) - CALCULATE([Discount Amt], 'Date'[Year] = 2026) * (1 + [Discount Change])) * (1 + [Volume Change])

WhatIf Profit = [WhatIf Revenue] - CALCULATE([Cost], 'Date'[Year] = 2026) * (1 + [Cost Change]) * (1 + [Volume Change])

Target Margin = 0.5

Price Change Needed = DIVIDE(CALCULATE([Cost], 'Date'[Year] = 2026) * (1 + [Cost Change]) / (1 - [Target Margin]) + CALCULATE([Discount Amt], 'Date'[Year] = 2026) * (1 + [Discount Change]), CALCULATE([Gross Sales], 'Date'[Year] = 2026)) - 1

Recommendation = IF([Margin % 2026] < 0.45, "Fix price / cut discount", IF([ΔPY %] < 0, "Find the cause, push sales", IF([ΔPY %] >= 0.1, "Invest to grow", "Keep steady")))

Revenue Trend =
VAR pts = ADDCOLUMNS(SUMMARIZE(ALL('Date'), 'Date'[MonthIndex]), "@rev", [Revenue])
VAR fit = LINESTX(pts, [@rev], 'Date'[MonthIndex])
VAR slope = SELECTCOLUMNS(fit, [Slope1])
VAR icpt = SELECTCOLUMNS(fit, [Intercept])
RETURN icpt + slope * MAX('Date'[MonthIndex])

Correl Discount vs Qty =
VAR n = COUNTROWS(Sales)
VAR mx = AVERAGE(Sales[Discount]) VAR my = AVERAGE(Sales[Qty])
VAR cov = SUMX(Sales, (Sales[Discount] - mx) * (Sales[Qty] - my))
VAR sx = SQRT(SUMX(Sales, (Sales[Discount] - mx) ^ 2)) VAR sy = SQRT(SUMX(Sales, (Sales[Qty] - my) ^ 2))
RETURN DIVIDE(cov, sx * sy)