Forum Discussion

learner03's avatar
learner03
Post Partisan
4 years ago
Solved

Cumulative sum Problem

My Cumulative Sum measure is not calculating correctly.  I have a "Is In Range" column that show 1 for weekday starting today and 0 for weekend. I want to make a table out of it with first column a...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

In calculating the cumulative sum column, what is the relevance of the 1's and 0's in the "Is in range" column?

learner03's avatar
learner03
Post Partisan
4 years ago

Hi Ashish_Mathur The cumulative Sum should start from the range where it says 1. This is because 1 starts from Today. So, in this case I need cumulative sum to start from 232 instead of 358.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.