Previous Year sales measure not working

[rynoh22]

Hello,

I have a set of data with sales, customers, sales reps, and month & year. I'm trying to pull last the previous year sales with

Prior Year Sales = CALCULATE(
	SUM(
		'Sales Data'[Sales]),
		DATEADD(
			'Sales Data'[Date],
			-1,
			YEAR
		)
)

I'm checking it in a matrix set up as Rows: Year, Quarter, Month. Values: Sales and Prior Year Sales.

The sales column is just fine. The Previous Year Sales column is populating as blanks everywhere except a total at the bottom.

Please help me with this.

Ryan

[hemamaleni]

I am having similar issue. Very simple file yet not able to get the YoY values. Can you help me understand where I am wrong?

[v-huizhn-msft · Accepted solution]

Hi @rynoh22,

As I tested, you'd better create a Calendar table, create a relationship between Calendar table and Sales Data table.

Create measure using the following formula.

Prior Year Sales = CALCULATE(
	SUM(
		'Sales Data'[Sales]),
		DATEADD(
			'Calendar'[Date],
			-1,
			YEAR
		)
)

Create a table visual, select Calendar[Date].Year, Calendar[Date].Quarter as rows, you will get expectd result.

If you have other issues, please feel free to ask.

Best Regards,
Angelia

[tchauphla]

Hey 
I have followed the query. But table is depicting the next year as well. 

Can you help with that?

[rynoh22]

That worked. I think my issue was that I was using the Date field from the Sales Data Table instead of the Date table.

Thank you @v-huizhn-msft