Power Pivot - Reverse Cumulative Measure

JamesAs

New Member
Joined
Mar 12, 2020
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
Hi,
Complete novice here within Power Pivot (But we've all got to start somewhere!)

Trying to create a visualization that shows a sort of burndown of tasks from left to right. I've utilized a measure which cumulates the total qty of tasks (some 380) of which 211 have been completed...but i'd like the inverse of this displayed. I've tried a method of reverse cumulation but just shows the tasks completed burning down not the total tasks leading down to remaining.

Help!






Cumulative Quantity All:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] <= MAX ( 'Dates'[Date] )
)
)

1596040252667.png




Cumulative Quantity test:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] >= MIN ( 'Dates'[Date] )
)
)


1596040470889.png




Main Table

TaskCR=1CompleteDate Complete
T1234511
14/07/2020​
T123461(Blank)
T1234711
12/07/2020​
T1234811
13/07/2020​
T1234911
14/07/2020​
T123501(Blank)
T1235111
15/05/2019​
T1235211
16/05/2019​
T123531(Blank)
T1235411
25/06/2020​
T1235511
26/06/2020​
T123561(Blank)
T1235711
24/01/2020​
T123581(Blank)
T123591(Blank)
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,118,968
Messages
5,575,277
Members
412,653
Latest member
JyothiGrace
Top