Forum Discussion

Anonymous

Not applicable

8 years ago

HELP: Cumulative Running Total

Hello Everyone; I am seeking help on my power BI report. Ive been wandering in every site searching for possible solution for my problem. I saw some but still could not get it rght. I would l...

Anonymous

Not applicable

8 years ago

I tried deleting it quentin_vigne but i think it is default in my end.

Icon for Solution Sage rank

Solution Sage

8 years ago

Anonymous

Are you creating a measure ? It must be a measure, not a calculated column

Else can you please provide a sample of data so that I can copy and paste it to try the formula ?

- Quentin

Anonymous
Not applicable
8 years ago
Hello quentin_vigne; APologies, instead of Reply i click the Accepted Solution. My apologies. Anyways, how will you be able to determine if it is a measure or calculated column?

Sample Report:
Row Labels Plan:Execution Plan:Peer Review Plan:SL Review
6/6/2018
6/7/2018 6532 6186 854
6/8/2018 4176 4202 7396
6/11/2018 1300 1619 2943
6/12/2018 46 47 861

Power BI Table should look like the below:
Row Labels Plan:Execution Plan:Peer Review Plan:SL Review
6/6/2018
6/7/2018 6532 6186 854
6/8/2018 10708 10388 8250
6/11/2018 12008 12007 11193
6/12/2018 12054 12054 12054

-ving.
- quentin_vigne
  Solution Sage
  8 years ago
  Anonymous
  
  I'm sorry for misleading you you need to create a new calculated column and not a new measure
  
  try this :
  
  Plan:Execution2 = CALCULATE ( SUM ( Raw Data(Exe)'[Plan:Execution]), ALL ( Raw Data(Exe)'), Raw Data(Exe)'[Date] <= EARLIER (Raw Data(Exe)'[date]) )
  - Quentin
  - Anonymous
    Not applicable
    8 years ago
    Hello quentin_vigne;
    I have a question, why do you change the Column Name Work Category to Plan:Execution
    the portion after "EARLIER" i can no longer change the value. It gray's out.
    Am i using thr right table? Matrix?

Related content