// QueryAndChart — quarter-to-date sales measures
// Paste into Power BI Desktop: Modeling > New measure, one measure at a time.
// Tables: Sales (Month, Category, Units, Revenue), Calendar (Date).
// Relationship: Calendar[Date] (one) to Sales[Month] (many), single direction.
Total Sales = SUM ( Sales[Revenue] )

Sales QTD =
TOTALQTD (
    [Total Sales],
    Calendar[Date]
)

Sales QTD PY =
CALCULATE (
    [Sales QTD],
    SAMEPERIODLASTYEAR ( Calendar[Date] )
)

QTD YoY % Change =
DIVIDE (
    [Sales QTD] - [Sales QTD PY],
    [Sales QTD PY]
)