The Part of Data Modelling Everyone Skips (That Breaks Everything Later)
Your measure is right, your data reconciles, and your year-to-date is still wrong - because the model never had a real date table, only a date column pretending to be one.
Date Table
// 1 postPosts about Date Table.