Forum Discussion
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(),...
Using the auto-generated date/time hierarchies is one of the worst things you can do in Power BI. Please never do this. Stick to a calendar that you either import or create in Power Query. You'll then always be safe and will reduce the model size as well.