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
Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
9 years ago

Hi umpoohg

 

The syntax of your measure is correct but:

 

1. Did you make sure you have created a relationship between Calendar and Sales Table ?

2. What is the current filter context regarding Calendar ? Do you use a slicer or a 'row'/'column' argument from the calendar table to filter the data ?

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))