Forum Discussion

SalvaC's avatar
SalvaC
Icon for Advocate III rankAdvocate III
5 months ago
Solved

Interesting effects with calendar-based time intelligence

Hi guys   After some research and testing, I found several interesting effects with the new calendar-based time intelligence.   For example, how dates are shifted when calculating the PY with lea...
"DAX"
"Time Intelligence"
Custom calendar
  • v-hashadapu's avatar
    v-hashadapu
    3 months ago

    Hi SalvaC , 

    when you expanding 2023, it changes the PY results of 2024. It is a bug in the new calendar-based DATEADD() implementation for custom weekly calendars in that specific semantic model. Instead of using calendar-based time intelligence, better to use Classic Time Intelligence. Please try below measure.

     

    Online Sales PY Weekly-Dates  =
    CALCULATE(
        [Sum Online Sales],
        DATEADD('Week-Date Calendar'[Date], -1, YEAR)
    )

     

    The new calendar-based TI behaves differently because it works from the tagged calendar and its current filter context.


    If you are still experiencing the issue, as you mentioned, the new datamodel (ContosoRetail_Sale) is working fine, but the problem persists with the old datamodel (ContosoRetail_Small). Please update the Date hierarchy fields in the old datamodel to match those in the new datamodel. Refer to the screenshots above for guidance.

SalvaC's avatar
SalvaC
Icon for Advocate III rankAdvocate III
5 months ago

Hi FBergamaschi 

 

Thanks.

You are very welcome to give feedback or if you can provide an answer for the issues I wasn't able to find a solution.

 

Where would be the correct place to post this?

 

Kind regards

Salvatore

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    4 months ago

    Hi SalvaC 

    please send me the linkd to the questions you could not find an answer for, especially on DAX and I shall support.

     

    I would consider a blog among the ones you have options to choose in this forum for the post on the new Time Intelligence

     

    Best

    F

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI