Forum Discussion

sebastienm1's avatar
sebastienm1
Frequent Visitor
5 months ago
Solved

Calendar-based Time Intelligence Preview - Issue

Hi, Using the Preview of the Calendar-Based Time Intelligence , I have created a Fiscal Calendar in order to simplify the measures' expressions. However, one of the Associated Columns is giving me a...
Need Help
  • sebastienm1's avatar
    sebastienm1
    5 months ago

    Hi all,

    Over the weekend, I found out that the validation of the calendar was failing with Calculated Columns, so I moved the computation to Power Query instead and this fixed the issue. As far as I can tell, this isn't mentioned in the documentation. It took me a while to figure this one out. 
    Thank you for your help,

    -- Sebastien

sebastienm1's avatar
sebastienm1
Frequent Visitor
5 months ago

Hi all,

Over the weekend, I found out that the validation of the calendar was failing with Calculated Columns, so I moved the computation to Power Query instead and this fixed the issue. As far as I can tell, this isn't mentioned in the documentation. It took me a while to figure this one out. 
Thank you for your help,

-- Sebastien

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 months ago

    Hi sebastienm1 ,
    Thanks for sharing your insgihts, this is really helpful. What you observed does make sense, as the calendar-based time intelligence preview seems to work more reliably when the required date columns are created during data load rather than as DAX calculated columns. Moving the logic to Power Query makes those columns part of the model itself, which allows the validation to pass. So your workaround will definitely help others who run into the same issue.