DAX / SQL Explainer

Plain-English translation for measure and query logic.

Paste a DAX measure or SQL query and the agent will explain it line-by-line, flagging filter-context and grain caveats.

Revenue YTD =
  TOTALYTD(
    SUM( FactRevenue[Amount] ),
    'Date'[Date]
  )

Explanation DAX

This is a DAX measure. It produces a single scalar value evaluated against the current filter context of the report (e.g. the slicers, axis, and row currently in scope).

Breakdown

TOTALYTD walks from the start of the selected fiscal year up to the current date filter context.
SUM aggregates the column over the active row context.

Caveats

Filter context is implicit — moving this measure to a different visual will change its result.
Verify date table relationships are marked as a Date table for time-intelligence functions to work.