Forum Discussion

seanguerrero's avatar
seanguerrero
Helper I
3 years ago
Solved

Dynamic SAMEPERIODLASTYEAR

Hi PBI users,   I'm looking to create a dynamic SAMEPERIODLASTYEAR calculation. I have a Matrix visual where you can drill down between Year, YYQQ and YYMMM. After a user drills down and selects th...
  • lbendlin's avatar
    lbendlin
    3 years ago

    SAMEPERIODLASTYEAR is syntax sugar for DATEADD. As long as you use a suitable date column (contiguous and covering) it doesn't matter what period you are looking at.

lbendlin's avatar
lbendlin
Super User
3 years ago

SAMEPERIODLASTYEAR is syntax sugar for DATEADD. As long as you use a suitable date column (contiguous and covering) it doesn't matter what period you are looking at.