Forum Discussion

LizardBoi's avatar
LizardBoi
Regular Visitor
4 years ago
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...
Need Help
  • richbenmintz's avatar
    richbenmintz
    4 years ago

    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,

  • LizardBoi's avatar
    LizardBoi
    Regular Visitor
    4 years ago

    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's avatar
      richbenmintz
      Resident Rockstar
      4 years ago

      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,