IssueWhen YEAR([Date]) and MONTH([Date]) are together on 'Rows' or 'Columns' and the first YEAR() present only contains a few months, the YoY quick table calculation will reference the wrong month.
In the workbook YoY Quick Table Calculation.tbwx attached to this article, you will find an example of an issue and the resolution. For more details, see the information below:
- We would expect January through March of 2015 to use YoY from 2014, which they are.
- We would also expect December and November of 2014 to use the same months in 2013 for it's YoY.
- Instead, since November and December are the 'first two months present in 2013', they are treated as though they are January and February.