![]() ![]() So, all values will be calculated for the same date – with all value after this date not being used / considered. ![]() Note: This blog was written on April-15-2018. Each week’s year is the Gregorian year in which the Thursday falls. The extra week is sometimes referred to as a leap week, although ISO 8601 does not use this term. That is 364 or 371 days instead of the usual 365 or 366 days. We will be considering a sample data file for this example that is created for all days from Jan-1-2017 to Dec-31-2018 with some random values. What is ISO year An ISO week-numbering year (also called ISO year informally) has 52 or 53 full weeks. those from last year until today (including today). In essence what we are trying to do is simply evaluate the YTD (Year to Date) for the CY (Current Year) Vs. the PY (Previous Year) – note, there are different methods to do this and we will be discussing two type of calculations. ![]() In this blog, we will be comparing values from this year Vs. The list goes on as long as there is data.
0 Comments
Leave a Reply. |