Calculate percent difference between two Matrix Columns

[nsadams87xx]

Hey everyone,

I have a dataset that has previous year's data and this year's data in one column:

Is there a way I can calculate the sum percentage delta between the previous year and the current year as it sits or do I need to modify the data model?

[amitchandak]

You can also use year behind measure with Date dimesnion

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

[nsadams87xx]

Nevermind, I forgot about sameperiodlastyear.