Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Running Total based on Index

Hello, I’m new to DAX and I’m trying to get a Running Total (Supply and Demand) based on the column SKU Index: What I’m trying to do is to replicate the next formula: =IF(N2=1, J2, I1+J2-K2) The ...
Need Help
  • ChenwuZhu_Gmail's avatar
    ChenwuZhu_Gmail
    4 years ago

    Hi Anonymous ,

     

    Did you solve your problem, if yes, please mark it as a solution, if not, please try these codes below to do that.

     

    My table looks like:

     

    New column to calculate:

    Column =
SUMX (
    FILTER (
        'Table',
        [SKU] = EARLIER ( 'Table'[SKU] )
            && [SKU Index] <= EARLIER ( 'Table'[SKU Index] )
    ),
    [+] - [-]
)

     

    Result:

     

    Measure:

    Measure =
SUMX (
    FILTER (
        ALLSELECTED ( 'Table' ),
        [SKU] = SELECTEDVALUE ( 'Table'[SKU] )
            && [SKU Index] <= SELECTEDVALUE ( 'Table'[SKU Index] )
    ),
    [+] - [-]
)

     

    Result:

     

    Best regards.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi! Yes, sorry I forgot to mention that, but it is the last column called SKU index.  

I actually used the first video you suggested from Goodly to create it, and now with that sub category index, I think it is feasible to perform a running total based on that column. 

  • ChenwuZhu_Gmail's avatar
    ChenwuZhu_Gmail
    Resolver I
    4 years ago

    Hi Anonymous ,

     

    Did you solve your problem, if yes, please mark it as a solution, if not, please try these codes below to do that.

     

    My table looks like:

     

    New column to calculate:

    Column =
SUMX (
    FILTER (
        'Table',
        [SKU] = EARLIER ( 'Table'[SKU] )
            && [SKU Index] <= EARLIER ( 'Table'[SKU Index] )
    ),
    [+] - [-]
)

     

    Result:

     

    Measure:

    Measure =
SUMX (
    FILTER (
        ALLSELECTED ( 'Table' ),
        [SKU] = SELECTEDVALUE ( 'Table'[SKU] )
            && [SKU Index] <= SELECTEDVALUE ( 'Table'[SKU Index] )
    ),
    [+] - [-]
)

     

    Result:

     

    Best regards.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This is indeed really helpful and works exactly as expected, thanks a lot