Have a question on how to get the late year totals.
Fact table has the Journal entries and fiscal year & periods . Fiscal year is from May to April.
I see that most examples use the date table and set relation with date in the fact table. How can the time series function if i do not have a date in the fact table ?
Need to provide a totals for location wise comparison. Reading through the time series functions and was not sure if i would need a date table to resolve this, but since fact does not have a date how can that help.
Here is my model -