Power BI Cumulative Sum

[Petan65]

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]),

'MORAVIAPRESS$G_L Entry'[Date] <= MAX('MORAVIAPRESS$G_L Entry'[Posting date])))

I'm already desperate

Thank you

[v-rongtiep-msft · Accepted solution]

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.

[Avantika-Thakur]

Hi @Petan65 ,

Can you please help elaborate your query with some sample data and what is expected as a result out of this DAX?

This DAX expression itself doesn't clarify your query.

Thanks!
Avantika