Forum Discussion
joshua1990
Post Prodigy
Post ProdigyChanges / Variance over time
Hey community! I have a sales table with the following columns: Order Nr Order Date Value Item I also have a budget table: Item Budget Month These tables are linked with the Item Key an...
daxer-almighty
Solution Sage
Solution SageIf you want to use a standard calendar to do this, it'll be almost impossible. For weeks you have to use one of the industry-standard calendars, for instance, the ISO-week calendar. This is because weeks do not go evenly into months....
joshua1990Post Prodigy
Post Prodigydaxer-almighty @Thanks! Actually I am working with a fiscal calendar with specific start dates for each fiscal month based on the 445 approach.
that should work, right?