Forum Discussion
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. ...
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
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