I have two columns, a measure and a date that when I put in my visual table I use the hierarchy and see only the month, I want to obtain the accumulated sum of "sum" by month and year, I attach an image of my data, the yellow column is what I should obtain and the green column is the result I have.
I already used the formula
TOTALYTD( REBATES_COM[net month], REBATES_COM[Posting Date])
and it doesn't give me the accumulated amount if I don't keep getting the green column.
Any idea what I can do?