Forum Discussion

KaroRoza's avatar
KaroRoza
Icon for Helper I rankHelper I
6 months ago
Solved

cummulative sum not working

Hi, Could someone help me on Cummulative sum? I have no idea why it is not working. I have two tables: Actuals and DimDate (relation one to many) In the dashboard I have selector DimDate( Year, Mo...
Need Help
  • johnt75's avatar
    johnt75
    6 months ago

    That's actually simpler DAX code, you can use the DATESYTD function

    Cumm Sum USD =
CALCULATE ( SUM ( 'Actuals'[Actual USD] ), DATESYTD ( 'DimDate'[Date] ) )
wardy912's avatar
wardy912
Icon for Super User rankSuper User
6 months ago

Hi KaroRoza 

 

 Please give the following a try:

 

Cumm SUM USD =
CALCULATE(
    SUM(Actuals[Actual USD]),
    FILTER(
        ALLSELECTED('DimDate'[Date]),
        'DimDate'[Date] <= MAX('DimDate'[Date])
    )
)

 

The FILTER iterates from the earliest visible date up to the current row date.

 

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

 

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!

 

Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi KaroRoza ,

Thank you wardy912  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.