Forum Discussion
Calendar-based Time Intelligence Preview - Issue
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
Hi. Thanks for the reply grazitti_sapna .
Having multiple rows with the same values shouldn't be an issue, as long as each Fiscal Year value has a single Relative Fiscal Year value and, vise versa, each Relative Fiscal Year value has a single Fiscal Year value.
A similar pair that works just fine -- and you can see in my previous post -- is the Fiscal Quarter and Fiscal Quarter Numeric.
InsightsByV , my Calendar table -- with Relative Fiscal Year selected, showing its expression -- from which i created a custom calendar 'Fiscal' as shown in my first post:
I noticed that the expression for Relative Fiscal Year uses a measure based on this same Calendar table, and while it works fine in a regular calendar, it is maybe creating a conflit in a Custom Calendar.
I replaced the expression by the temporary one : 2007 -'Calendar'[Fiscal Year], and again tried adding the column as Associated Column. Unfortunately, same issue when i click Validate data.
- InsightsByV
Super User
Hi,
Can you try creating separate table for years? Year =
SUMMARIZE(
'Calendar',
'Calendar'[Fiscal Year],
"Relative Fiscal Year", MAX('Calendar'[Relative Fiscal Year])
)"
then try to use fields from this above table instead of the main one?
Let me know if that helped!
