for someone who has the same problem, the solution is through disconnecting the relationships between my date table.
while it was active, my summarizecolumns would not work correctly since, somehow (better explained here: https://forum.enterprisedna.co/t/cumulative-by-selected-month-year/15146/4) it assumes only the month selected.
After disconnecting it, and with some minor changes needed due to my particular business case, it worked.
Thanks for anyone who lost time even thinking about it.