search

sql-bi / DaxDateTemplate

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

5-4-4 not generating correct quarters #36

Closed securus777 closed 4 years ago

securus777 commented 4 years ago

Good Morning,

Seems like when 5-4-4 is used the weeks are not falling into the correct quarters. For instance in the attached image you can see that 3/29 and 3/30 should show in Q2 as they are in week 14. image

Though I could be wrong on the config (544 is selected).

Thanks

marcosqlbi commented 4 years ago

Use FW columns when you use Fiscal Week calendar - the FW quarter column is correct. I suggest to remove the columns you don't need by removing the last few lines of the DAX Code, so you only have the calendar really needed, either Fiscal (based on months) or FW (Fiscal based on weeks).