Forum Discussion

sivashankr's avatar
sivashankr
Helper II
6 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

sivashankr , Can you share the formula. Hope you are using date from date table

Ideally, all the time intelligence functions will work with a continuous date. Now can of bi-directional date table is filtered from fact data. and may miss dates and time intelligence function will give an error

  • sivashankr's avatar
    sivashankr
    Helper II
    6 years ago

    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" ) ) )