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
Super UserHi sebastienm1,
Issue seems to be Multiple rows per fiscal year in your base table
For e.g.
You can fix it by creating a mapping table like below
FiscalYearMapping =
DISTINCT (
SELECTCOLUMNS(
'Date',
"Fiscal Year", 'Date'[Fiscal Year],
"Relative Fiscal Year", 'Date'[Relative Fiscal Year]
)
)
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!