Forum Discussion

Robbief's avatar
Robbief
Icon for Helper II rankHelper II
9 years ago
Solved

The dreaded "SAMEPERIODLASTYEAR" Function

Hi Guys - I was wondering if someone could perhaps help....  I've spent a day on this, read just about every forum post, but I'm clearly missing something in relation to the SAMEPERIODLASTYEAR functi...
Need Help
  • mattbrice's avatar
    mattbrice
    9 years ago

    Not sure what you mean. Results look as expected.  2017 SalesLastYTD is showing 2016 YTDSumOfSales, etc.  

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

Not sure what you mean. Results look as expected.  2017 SalesLastYTD is showing 2016 YTDSumOfSales, etc.  

  • Robbief's avatar
    Robbief
    Icon for Helper II rankHelper II
    9 years ago

    Thanks for pointing out the obvious to me.  I ended up going in circles; and getting confused with the Sameperiodlastyear / parrallelperiod / dateadd.....  But I realised I was being stupid, and after reading a few more articles, i figured it out. 

     

    This really helped:

    https://www.kasperonbi.com/powerpivot-dax-parallelperiod-vs-dateadd/