Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Cumulative datas with slicer

Hello!  In the table attached i have 2 kind of date attributes from which i will draw at the end 2 cumulated line diagram... Each row has an attribute for a type. So... if i put this types in a sl...
  • suparnababu8's avatar
    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!