Find my approach based on a "scaffold"-dataset stored in attached workbook version 10.5 located in the original thread.
1. Define a Scaffold-dataset
2. Define the Scaffold dataset as primary dataset
3. Define D1. Date based on de primary dataset: DATE(DATEPARSE ( "MM-dd-yyyy", '1-1-'+str((2015 +[Year ID])) ))
4. Define M1. Value: zn(SUM([Sheet1 (rawdata)].[Value]))
5. Drag the required objects to the indicated locations
Hope it helps,