Convert fiscal Yearmonth to Calendar YearMonth

[rido1421]

Hi There

Please can you assist me with a method to convert Fiscal YearMonth to Calendar YearMonth

The Fiscal Year starts in October

Much Appreciated

Regards,

[rido1421]

I have a sales model and need to link the budgets to it, in the budgets table I have the Fiscal Date  and need to link to the sales Fact, I cannot link on the Fiscal Date as this causes other complications, I need to link using the Calendar Date but I need to create this in my budget table from the Fiscal Date...

Fiscal Date= 20150101.

Calendar Date=20141001.

Any Suggestions will be appreciated

[Ralf-Narfeldt · Accepted solution]

CalendarDate=AddMonths(FiscalDate,-3)

[jagan]

Hi,

Subtracting 3 month from your Fiscal date gives you the Calendar Date?  If so you can do this by using AddMonths()

LOAD

*,

AddMonths(FiscalDate, -3) AS CalendarDate

FROM DataSource

Hope this helps you.

Regards,

Jagan.