M Function - calculate running total

Is there a way to create a function in 'Edit Query' that summarises a column by month to date per year? Give it for example a parameter of a date field and the column you need calculated and adds an extra column with MTD by year?