Creating MTD (the easy way) with Custom Expression

There is a lot of questions on the forum concerning getting MTD/YTD, but I can not see any easy answers.

Here is the way that I do it with a Custom Expression. Simply add your date and measure. Sort the table ASC on the Date:

sum(offset_list(${transactions.count:row_total}, 0, extract_days(${transactions.date})))