topic Power BI Cumulative Sum in DAX Commands and Tips

Power BI Cumulative Sum

Petan65 — Fri, 22 Jul 2022 07:52:49 GMT

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

Re: Power BI Cumulative Sum

Avantika-Thakur — Fri, 22 Jul 2022 10:50:24 GMT

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

Re: Power BI Cumulative Sum

Anonymous — Tue, 26 Jul 2022 03:19:11 GMT

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.