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])

singhv2's avatar
singhv2
Helper I
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])