Forum Discussion
Solved
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 wee...
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,
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,