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] )
)
)
Cumulative Quantity test:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] >= MIN ( 'Dates'[Date] )
)
)
Main Table
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] )
)
)
Cumulative Quantity test:=CALCULATE (
SUM ( 'MAIN TABLE'[CR =1] ),
FILTER (
ALL ( 'Dates'[Date] ),
'Dates'[Date] >= MIN ( 'Dates'[Date] )
)
)
Main Table
| Task | CR=1 | Complete | Date Complete |
| T12345 | 1 | 1 | 14/07/2020 |
| T12346 | 1 | (Blank) | |
| T12347 | 1 | 1 | 12/07/2020 |
| T12348 | 1 | 1 | 13/07/2020 |
| T12349 | 1 | 1 | 14/07/2020 |
| T12350 | 1 | (Blank) | |
| T12351 | 1 | 1 | 15/05/2019 |
| T12352 | 1 | 1 | 16/05/2019 |
| T12353 | 1 | (Blank) | |
| T12354 | 1 | 1 | 25/06/2020 |
| T12355 | 1 | 1 | 26/06/2020 |
| T12356 | 1 | (Blank) | |
| T12357 | 1 | 1 | 24/01/2020 |
| T12358 | 1 | (Blank) | |
| T12359 | 1 | (Blank) |
