Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SAMEPERIODLASTYEAR issue

Hi,   Having an issue whereby using SAMEPERIODLASTYEAR it's not recognising a date column, even though it's definitely formatted that way.   DAX...   PGT Previous = if([PGT Int Pop] = BLANK(),...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , remove .year. But better use a date table

PGT Previous = if([PGT Int Pop] = BLANK(), BLANK(), [PGT Int Pop] - CALCULATE([PGT Int Pop], SAMEPERIODLASTYEAR('Academic Year Conversion'[Academic Year])))

 

PGT Previous = if([PGT Int Pop] = BLANK(), BLANK(), [PGT Int Pop] - CALCULATE([PGT Int Pop], SAMEPERIODLASTYEAR('Date'[Date])))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.