Forum Discussion
LYTD Contiguous Issue
HI Team, I created LYTD using SAMEPERIODLASTYEAR function, but it throws me the error as shown in below screenshot. Then I changed the bi-drectional filter single it works but shows incorrect aggre...
Hi amitchandak and parry2k ,
I resolved this by the below formula. Thanks a lot for taking your time to look into this.
CALCULATE (metric, SAMEPERIODLASTYEAR ( DATESYTD( 'CALENDAR'[Date],"31/7" ) ) )
sivashankr well done.