Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCreate / Generate Fiscal Calendar - Best Practice
In the past I have generated our fiscal calendar in Dataflow Gen 1 using PQ. This calendar table was shared accross different workspaces and reports. Considering to upgrade the workspace to fabric ...
Hi joshua1990 ,
Select the method that best suits your expertise (Power Query, SQL, Python) and the complexity of your time intelligence calculations. Each option guarantees that the enriched fiscal calendar is centralized and accessible across Fabric workspaces and reports.
Thank you, lbendlin & suparnababu8 , for your prompt and helpful responses.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super UserFiscal calendars are immutable. There is no need to calculate them over and over again. Use an external, precomputed, reference table
joshua1990Yes and now. The skeleton should be sourced from an ERP etc, but I need to add some additional time intelligence columns.