Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with ISO dates!!

Hello everyone, I'm trying to set up a report for my company and am facing difficulties calculating correct YTD and YTD-1 measures due to the fact that the date format in the data source is odd. ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    I'd like to suggest you create a calendar table with the custom 'year week' field to link to the current table fields. Then you can use the related date field values for YTD calculations.

    Regards,

    Xiaoxin Sheng

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try if this can help

New column = Weeknum([Date],21)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello amitchandak. Okay, I've made the column. How should I proceed?
    Thank you