Forum Discussion
Cumulative datas with slicer
- 2 years ago
Hi Anonymous
Based on my understanding, I'm answering this question. It might be correct/wrong. Pls follow the steps.1) Create Planned date calculated column for cumulative counts. use the below measure
Cumulative Planned = CALCULATE( COUNTROWS('Table'), FILTER( ALL('Table'), 'Table'[Planed Date] <= EARLIER('Table'[Planed Date]) ) )2) Create Actual date calculated column for cumulative counts. use the below measure
Cumulative Actual = CALCULATE( COUNTROWS('Table'), FILTER( ALL('Table'), 'Table'[Actual Date] <= EARLIER('Table'[Actual Date]) ) )Then use this measures as shown in below snapshots.
-------------------------------------------
Use the slicer to filter the values as mentioned below snapshot.
I hope it will help you.
Thanks!
Hi Anonymous
Based on my understanding, I'm answering this question. It might be correct/wrong. Pls follow the steps.
1) Create Planned date calculated column for cumulative counts. use the below measure
Cumulative Planned =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALL('Table'),
'Table'[Planed Date] <= EARLIER('Table'[Planed Date])
)
)
2) Create Actual date calculated column for cumulative counts. use the below measure
Cumulative Actual =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALL('Table'),
'Table'[Actual Date] <= EARLIER('Table'[Actual Date])
)
)
Then use this measures as shown in below snapshots.
-------------------------------------------
Use the slicer to filter the values as mentioned below snapshot.
I hope it will help you.
Thanks!
- Anonymous1 year agoNot applicable