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 it could not add the field to the Pivot Table because the formula is invalid.
My month-year column in my fact table is connected to the dimension table of dates.
How do i fix this? Thanks a million.
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 it could not add the field to the Pivot Table because the formula is invalid.
My month-year column in my fact table is connected to the dimension table of dates.
How do i fix this? Thanks a million.