Forum Discussion

singhv2's avatar
singhv2
Helper I
8 years ago
Solved

Running total Until Current Month

Hi There,   I'll really appreciate somone's urgent support.   I've gone through multiple Running Total examples, however, I am not sure if it's helping me out. I'll appreciate someone's help.   ...
Need Help
Show and Tell
Tips and Tricks
  • singhv2's avatar
    singhv2
    8 years ago

    I've came across another method.

     

    Get the first date of the POBU with first True case. i.e. Process Flow = 1

     

    First Date = CALCULATE

                                         (MIN(Table[PO Create Date - Date].[Date]),

                                         FILTER(ALL('Standard Naming Detail - All - Metrics - V1'),Table[POBU]=EARLIER('Table'[POBU]) && Table [Process Flow]="1")

     

    Once the First Date Column is created, get the Cummulative Total using the below DAX:

     

    Pareto Total Per Month =
    VAR
    CurrentTotal = 'Table'[First Date]
    Return
    SUMX(FILTER('Table','Table'[First Date]<=CurrentTotal),'Table'[Process Flow])

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi singhv2

How about running these query respectively

flag =
    IF (
        [Process Flow] = 0,
        BLANK (),
        CALCULATE (
            SUM ( 'table'[Process Flow] ),
            FILTER ( ALLEXCEPT ( 'table', 'table'[POBU] ), [Index] <= EARLIER ( [Index] ) )
        )
    )

new flow =
IF ( flag > [Process Flow], 0, [Process Flow] )

total = CALCULATE(SUM([new flow]),FILTER(ALL('table'),[Index]<=EARLIER([Index])))

Best regards

Maggie

singhv2's avatar
singhv2
Helper I
8 years ago

Hi Maggie,

 

It's still not helping.