Hi @Emily Hua-MSFT , thanks for the response,
I modified the expression having looked a bit further. I created a dates table from 1/Jan/2020 through to end 2024, and changed the expression to
=TOTALYTD([Distance Cycling],DATESYTD(calendar[Date])). I've made the table that long as I want the YTD to automatically update each year with a slicer.
If I select Pivot by months, this is now giving me values, but each month value is equal to the sum of that month only, whereas what I'm trying to do is Month 2 YTD = Month 2 + Month 1 etc.
There is no sensitive data here, I'm just trying to get used to using the expressions, playing around with my exercise data. Effectively I'm learning to do what I've been doing through SUM, SUMIF and SUMIFS, COUNT functions etc.
How do I share the file? Excel is not an allowed attachment type.