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 aggregation.


Can u please help me how to fix the LYTD calculation without chanaging the bi-directional filter to Single, I want it to be Both.

 

 

 

 

Need Help

4 Replies

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

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    sivashankr As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

    https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/

     

    And now use SAMEPERIODLASTYEAR using this date table.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡