sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
269 stars 76 forks source link

VAR FiscalCalendarFirstMonth = 1 #13

Closed jasonhendrix closed 5 years ago

jasonhendrix commented 5 years ago

I've downloaded the 1.0.2 version, opened the PBIX file, and changed "VAR FiscalCalendarFirstMonth = 9" to "VAR FiscalCalendarFirstMonth = 1" instead.

After that change, the "Fiscal Year" is showing "F 2009" for a "Date" value of "1/1/2008 12:00:00 AM"

Shouldn't the "Fiscal Year" be "F 2008"?

marcosqlbi commented 5 years ago

You're right - I'll work on this and other bugs very soon.

marcosqlbi commented 5 years ago

This should be fixed with the 1.06 release.