same period last year but I don't have a measure

[jlanigan]

I have summary sales data table called Sales

I want to create a line chart with one line being the sales each month for 2024 and another one being the sales for same month last year.

I have a date table related to [Sales]MonthEnding

All the examples I'm finding for doing this are doing a CALCULATE on a total sales measure which calculates the total sales from individual sales lines, but I don't have sales lines to sum up for a measure.

What do I need to do?

[jlanigan]

Thanks Greg.

I really need to get my head around measures.  I can put together a decent report but i'm doing it all with filters and some calculated columns, almost zero measures.

[Greg_Deckler]

@jlanigan Try my DAX For Humans YouTube channel: DAX for Humans - YouTube

[Greg_Deckler · Accepted solution]

@jlanigan Try:

Measure = 
  VAR __Date = MAX('Sales'[MonthEnding])
  VAR __PYDate = EOMONTH( __Date, -12 )
  VAR __Table = FILTER( ALL('Sales'), [MonthEnding] = __PYDate )
  VAR __Result = SUMX( __Table, [Sales] )
RETURN
  __Result