Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cummulative sum not working

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!

 

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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!