I am trying to use SAMEPERIODLASTYEAR in a PowerPivot table to return the values for the same date in the previous year. It only returns numbers for the current period. The Dates table I am using has contiguous dates, but the data does not. is this the problem? What am I doing wrong?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
SAMEPERIODLASTYEAR Returning Numbers for Same Period Current Year
- Thread starter tdecicco
- Start date
Excel Facts
Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
I am trying to use SAMEPERIODLASTYEAR in a PowerPivot table to return the values for the same date in the previous year. It only returns numbers for the current period. The Dates table I am using has contiguous dates, but the data does not. is this the problem? What am I doing wrong?
No, this is not the problem. Your Dates Table must have contiguous dates.
Is the Dates Table "Marked As Date Table" in your Power Pivot model?
Please post the exact formula you are using so that you can get help.
Upvote
0
Similar threads
- Replies
- 7
- Views
- 340
- Question
- Replies
- 0
- Views
- 398
