search

sql-bi / DaxDateTemplate

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

445 QuarterWeekType #72

Closed russmatthews closed 1 year ago

russmatthews commented 1 year ago

I have made the settings for line 17 to 445 and line 18 to FiscalWeekly. I'm trying to get a 445 QuarterWeekType but as you can see, it is 444 and creating a 13th period. Is there a setting I am missing to achieve the 445? Screenshot 2022-09-12 162543 Screenshot 2022-09-12 162717

marcosqlbi commented 1 year ago

FW Period is a fixed 4-week period. You want to use FW Month instead.

marcosqlbi commented 1 year ago

Please also consider using Bravo for Power BI which is simpler to use and only generates the columns required.