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
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

umpoohgIt looks like you have a Calendar Table and you are using the Year field from it in the Table Visual

 

These Measures should work...

Total = SUM ( 'IHead'[Sales] )

PY Total =
CALCULATE ( SUM ( 'IHeads'[Sales] ), PREVIOUSYEAR ( 'Calendar'[Date] ) )

YoY % Change =
DIVIDE ( ( [Total] - [PY Total] ), [PY Total], 0 )

Hope this helps.

Good Luck! :smileyhappy:

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

    Thank you so much for your reply!!  I have my measures as so:

    Total Sales = SUM(IHeads[Sales])

    Total Sales LY = CALCULATE(SUM('IHeads'[Sales]), PREVIOUSYEAR('Calendar'[Date]))

    % Chg vs LY = DIVIDE([Total Sales]-[Total Sales LY],[Total Sales LY]) 

     

    The only one that is not working is the Total Sales Last Year

     

    I have also tried:

    Total Sales LY = CALCULATE([Total Sales], PREVIOUSYEAR('Calendar'[Date]))

    Total Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Calendar'[Date])) - gives me contiguous date error

     

    • david40ni's avatar
      david40ni
      Icon for Helper I rankHelper I
      8 years ago

      I am facing the exact same problem its returning the same figures as the current year did you ever solve this at all?