OK, I've solved it myself. In the interests of sharing this with anyone else facing the same problem here is what was going wrong.
I was trying to create the YTD calculation as a row level function, where it should of course be an aggregate function and therefore be entered at the bottom of the table rather than in a row.
So my function is something similar to: =TOTALYTD(sum([Amount]);'Dates'[Date])