Forum Discussion

PrestaPower's avatar
PrestaPower
Frequent Visitor
7 years ago
Solved

SUM/Substract

Hey, so here is my issue. I have a table with for each year the client rejected after a certain step. Knowing that the total application is given on the last column, i would like to have in remaining...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi PrestaPower,

     

    Please follow steps below which may meet your requirement:

    1. Click Edit Queries-> Add Column-> Index Column 

    2. Create a calculate column running total using DAX formula below:

    Running Total =
CALCULATE (
    SUM ( Table1[Rejected after step] ),
    FILTER (
        Table1,
        Table1[Index] <= EARLIER ( Table1[Index] )
            && Table1[Year] = EARLIER ( Table1[Year] )
    )
)

    3. Achieve the remaining after each step

    Remaining after step = MAX(Table1[Total Applications]) + MAX(Table1[Running Total])

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi PrestaPower,

 

Please follow steps below which may meet your requirement:

1. Click Edit Queries-> Add Column-> Index Column 

2. Create a calculate column running total using DAX formula below:

Running Total =
CALCULATE (
    SUM ( Table1[Rejected after step] ),
    FILTER (
        Table1,
        Table1[Index] <= EARLIER ( Table1[Index] )
            && Table1[Year] = EARLIER ( Table1[Year] )
    )
)

3. Achieve the remaining after each step

Remaining after step = MAX(Table1[Total Applications]) + MAX(Table1[Running Total])

 

 

Regards,

Jimmy Tao