Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unexpected behavior Sameperiodlastyear

Hi,   I'm using the function sameperiodlastyear in some measures and they work fine for all periods besides the current month. I would expect to see the MTD value of lastyear's data there but it sh...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Anonymous 

    Did you make it look like this? dateadd('Date'[Date],-365,day)

    -1 is yesterday , -365 goes back to 12 months.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Try to use "day" as interval for your DATEADD instead of year.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amine,

 

thanks for your answer but this does not fix my problem, because I want to look at the same period but 12 months ago, not yesterday.

Chris

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous 

    Did you make it look like this? dateadd('Date'[Date],-365,day)

    -1 is yesterday , -365 goes back to 12 months.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amine,

       

      you are right, I read your solution to quickly. I have another visual where sameperiodlastyear shows me the correct value on a per year basis and your solution gives a slightly different value. Do you maybe know why? I've changed "-365" to different days to see if I could match the value from sameperiodlastyear but I cannot.

      What could be the logic behind this difference?

       

      Thanks,

       

      Chris