-
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.
sameperiodlastyear
-
H
How to calculate using Power Query YOY sales % when you only have year and month fields, but no date field? (Can't use SAMEPERIODLASTYEAR)
Hello fellow MrExcel forum users, How can I calculate using Power Query YOY sales % when you only have year and month fields, but no date field? (Can't use SAMEPERIODLASTYEAR)???- hofston
- Thread
- date field fields sameperiodlastyear year
- Replies: 0
- Forum: Excel Questions
-
C
SAMEPERIODLASTYEAR Function
Hello... I am in a middle of powerpivot where i have put a calculated field using SAMEPERIODLASTYEAR. Total Rev LY (AED):=CALCULATE([Total Rev (AED)],SAMEPERIODLASTYEAR(fPOSData[MonthYear])) It worked and it gave me a figure as a result. But when i am dropping it in the pivot table, it says...- Chers
- Thread
- powerpivot sameperiodlastyear
- Replies: 3
- Forum: Power Tools
-
H
Timeline and last year data
Hi everyone, I asking your help since I can't find a solution. I am working on a Financial scorecard. I am using Excel 2013 with powerpvot. I want my users using the new feature timeline since it is really sharpe. However, when someone select 2014 January, I also want 2013 January in order to...- hugodp
- Thread
- excel 2013 powerpiviot sameperiodlastyear timeline
- Replies: 0
- Forum: Power Tools
-
A
SAMEPERIODLASTYEAR is missing rows???
Hi all, I have a question on Powerpivot's SAMEPERIODLASTYEAR DAX function. On the surface the formula works perfectly..... however, on closer inspection there appears to be a bug. I am working with a dataset that contains information on customers from a number of stores. 1) When I first drag...- asderex
- Thread
- missing rows powerpivot sameperiodlastyear
- Replies: 0
- Forum: Power Tools
