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]),
'MORAVIAPRESS$G_L Entry'[Date] <= MAX('MORAVIAPRESS$G_L Entry'[Posting date])))
 
I'm already desperate
 
Thank you
  • 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.

2 Replies

  • 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.

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    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