Cummulative sum not working

[Anonymous]

Hello I have created teh following mesure to illustrate cummulative values. However, I simply get the value of each month. Any ideas what is wrong with the measure? Thanks!

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

I have noticed you have used a calender table and I have tested with my sample data, it could work on my side:

I wonder if you have created a relationship with your fiscal table and your calender table? when I deleted the relationship, I could reproduce your problem, so I suggest you to check if you have created the relationship and also download my pbix file to have a view.

Regards,

Daniel He

[Anonymous]

Hello,

indeed the issue was with the Date Dimension relationship. I have a relationship not in the Date attribute but in the DateSK which is e.g., 20180101 in any case I reinserted the Date Dimension and created a relationship between the Date columns. This solved the issue. Thanks for the hint!