← Files Power BI DesktopARCHIVED FILE

examples/sample-model/Sales.Measures.dax

285 Bytes · Oct 2, 2026 · 00:32 UTC

↓ Download file

'Sales'[Total Sales] =
SUM ( 'Sales'[Sales Amount] )

'Sales'[Sales YoY %] =
DIVIDE (
    [Total Sales] - [Total Sales Prior Year],
    [Total Sales Prior Year]
)

'Sales'[Total Sales Prior Year] =
CALCULATE (
    [Total Sales],
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)

SHA-256: 7994f4340bdc6f6b23e066a946fc6b76f16840b33a3010c110eee15bb7bcc753