Forum Discussion
Date table not calculating correctly
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
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,
3 Replies
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
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}})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,
