Last year same day sdata

[sadath]

Hi,
I have sales database like (Sales data of 2014 & 2015, daywise)

Store Name Date Sales


PT report Should Be

Date SalesLastYr SalesThisYr

here salesLastYr is same day last year (ie This year sales of 1st Jan should compare with 2nd Jan last year)
how will be DAX formula for calculating SalesThisYr & SalesLastYr.

please help

 

[Matt Allington]

well assuming you only want to do this for days, you could just write a formula like this.

=calculate([sales this year],dateadd(Calendar[date],-364,Day))

 

[sadath]

Hi
this formula works.. Thank you.

But I have another date filter, I cant add this to row filter.

please find the link also

https://drive.google.com/open?id=0B3EaAn3HZ8ZvOHhtMnhlMWk0Vjg

 

[Matt Allington]

But I have another date filter, I cant add this to row filter.

I'm not sure what you are saying here, and I can't access the file in the link