search

sql-bi / DaxDateTemplate

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

Issues with leap-year #51

Closed fol-debug closed 3 years ago

fol-debug commented 3 years ago

Hi,

So last year was a leap year, and now I'm having some issues with the generated Date-table from SQLBI.

The calendar should look like this, for 2021: attachment1

This is how it looks, however, when using your Date-table: image

So W53 should include the first three days of 2021, but it doesn't, causing every week after to shift to the next week.

marcosqlbi commented 3 years ago

For weekly-base calendar you should use the FW prefixed columns.