SQLDAXExcelPython
LeaderboardRunLifetime
Interview classicsHard30 points

Year to date for last year

Write a measure for last year's year-to-date [Total Sales], for the same point in the year.

Hard questions are part of Lifetime and Pro. Read it here, and unlock running and checking your answer from the plans.

How your answer is tested

Your code becomes a measure named [Answer] and runs in this query:

EVALUATE
CALCULATETABLE(
    SUMMARIZECOLUMNS(
        'Calendar'[MonthNumber],
        "Answer", [Answer]
    ),
    'Calendar'[Year] = 2024
)
Show solutionLifetime

Runs in your browser. The open-source dax-sql compiler turns DAX into SQL, so this isn't Microsoft's engine. The questions here were checked against Power BI Desktop, but free-form queries can occasionally differ.

DAX measure
Loading editor…

Press Ctrl+Enter or Run to see the result here.