Forum Discussion

Petan65's avatar
Petan65
Frequent Visitor
4 years ago
Solved

Power BI Cumulative Sum

Hello all,   could someone please help me where is in my DAX formula mistake?   Míra = CALCULATE( SUM ( 'MORAVIAPRESS$G_L Entry'[Sales] ) , FILTER( ALL('MORAVIAPRESS$G_L Entry'[Sales]), 'MORAV...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Petan65 ,

    Please have a try.

    Míra =
CALCULATE (
    SUM ( 'MORAVIAPRESS$G_L Entry'[Sales] ),
    FILTER (
        ALL ( 'MORAVIAPRESS$G_L Entry' ),
        'MORAVIAPRESS$G_L Entry'[Date] <= selectedvalue( 'MORAVIAPRESS$G_L Entry'[Posting date] )
    )
)

    If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output with more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Petan65 ,

Please have a try.

Míra =
CALCULATE (
    SUM ( 'MORAVIAPRESS$G_L Entry'[Sales] ),
    FILTER (
        ALL ( 'MORAVIAPRESS$G_L Entry' ),
        'MORAVIAPRESS$G_L Entry'[Date] <= selectedvalue( 'MORAVIAPRESS$G_L Entry'[Posting date] )
    )
)

If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output with more details.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.