Power Pivot - Reverse Cumulative Measure

JamesAs

New Member
Joined
Mar 12, 2020
Messages
6
Office Version
2016
Platform
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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,102,560
Messages
5,487,559
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top