Date table not calculating correctly

[LizardBoi]

Hi

Hoping someone can help with this.

I have a fiscal 544 date table set up with with the start of week set to Sunday (0)

Everything has been fine up to 2 weeks ago when the calculation of the week number has changed and moved it to a Saturday.

Why would it do this?  And how do I rectify it ?

TIA

[Greg_Deckler]

@LizardBoi How are you calculating your date table? I created one once in DAX: I created a custom 445 Calendar once: DAX Custom 445 Calendar - Microsoft Power BI Community

[LizardBoi]

Yes its a custom 544 one 

= Table.TransformColumnTypes(_5_4_4_Calendar_Table,{{"Date", type date}, {"Period Start", type date}, {"Weeks", Int64.Type}, {"Days", Int64.Type}, {"Period End", type date}, {"Period", Int64.Type}, {"FinYear", type text}, {"Date - Copy", type date}, {"NewWeekNo", Int64.Type}})

[richbenmintz · Accepted solution]

Hi @LizardBoi ,

Any chance you could share a pbix with your custom calendar table and query, would make it much easier to try to find the issue.

Thanks,