Forum Discussion

umpoohg's avatar
umpoohg
Icon for Helper I rankHelper I
9 years ago

Total Sales Last Year

Hello All,   I have a question that I have seen on here multiple times, however I am having an issue that I have not seen.  I have created a measure to display 'Last Years Sales' using the followin...
Need Help
umpoohg's avatar
umpoohg
Icon for Helper I rankHelper I
9 years ago

Yes, I thought of that right after I sent the original post.  Now that I am thinking, maybe it is still a  problem with this relationship

 

FuhaiLiu's avatar
FuhaiLiu
Frequent Visitor
9 years ago

Hi ,I use below calculation to return last year to date, ubt it returned last year plus this year to date. Any idea?

 

I have a  calendar table like below , and the year to date calculates fine.

 

Total Sales YTD = TOTALYTD([Total Sales],'Calendar'[Date])

 

 

Total Sales YTD LY = calculate([Total Sales YTD],dateadd('Calendar'[Date],-1,YEAR))