search

sql-bi / DaxDateTemplate

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

FW Period calculated incorrectly for 445 calendar #76

Closed KenLoewen closed 11 months ago

KenLoewen commented 11 months ago

Organizations using a 445 calendar have four quarters of exactly 13 weeks, four weeks in the first period, four weeks in the second period, and five weeks in the third period. In version 1.18 of the DAX Date Table, week 13 should be the last week of Q1 and in period 3 but it is in period 4. Likewise, weeks 17, 21, 25, 26, 29, 30, 33, 34, 37 - 39, 41 - 43, 45 - 47, and 49 - 52 are all in the wrong period (shifted to one higher numbered period.

KenLoewen commented 11 months ago

This is not a new issue - we're using version 1.11 in production and the error existed then - we've just confirmed it hasn't been fixed in 1.18.

KenLoewen commented 11 months ago

Found the FW Month field that contains the correct value