Forum Discussion

kolturra's avatar
kolturra
Helper IV
7 years ago
Solved

Cummulative SUM DAX ERROR

Hi,   I have issue DAX fomula with running total. I have done running total calculation in column F, what i have identify that my DAX formula is not populating same like manual calculation. Differe...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Sorry about that.  Try this one:

    Column = 
var __CurrentCreatedTime = Table2[CreatedTime]
RETURN

CALCULATE(
    SUM( Table2[Energy] ),
    FILTER( 
        ALL( Table2 ),
        __CurrentCreatedTime >= Table2[CreatedTime]
    )
)

    Did a check, and looks like the new column is what you would want:

    Also, be sure to set your data types in Power Query. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

try this code for a calculated column:

Column = 
var __CurrentDay = Table2[NewDay]
var __CurrentTime= Table2[TimeFactor]

RETURN

CALCULATE(
    SUM( Table2[Energy] ),
    FILTER( 
        ALL( Table2 ),
        __CurrentDay >= Table2[NewDay]
        && __CurrentTime >= Table2[TimeFactor]
    )
)
  • kolturra's avatar
    kolturra
    Helper IV
    7 years ago

    Hi Anonymous ,

     

    Thanks for your reply.

     

    Whatever DAX which you have shared and i have created are showing same results but both the DAX fomulas shows same errors at one place. Below screenshot for your reference. Can you plesae help me on this.

     

     

     

     

     

     

     

     

     

    Thanks,

    K Raghavender Rao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Sorry about that.  Try this one:

      Column = 
var __CurrentCreatedTime = Table2[CreatedTime]
RETURN

CALCULATE(
    SUM( Table2[Energy] ),
    FILTER( 
        ALL( Table2 ),
        __CurrentCreatedTime >= Table2[CreatedTime]
    )
)

      Did a check, and looks like the new column is what you would want:

      Also, be sure to set your data types in Power Query.