Forum Discussion

NT2510's avatar
NT2510
Frequent Visitor
5 years ago
Solved

Running Total blanks

Hello,   I have a table with two dates: Close Date, Accounting Date, amount and Month column (Close Date - Accouning Date)+1. I want running total of Amount based on Months.  I used below measure b...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, NT2510 

     

    You may try modifying the measure as below to see if it works.

    RunningAmount2 = 
var _max=CALCULATE(MAX(Sheet1[Mths]),ALLEXCEPT(Sheet1,Sheet1[Year]))
var _min=MIN( MAX('Table'[Value]),_max)
return
    CALCULATE(
        sum(Sheet1[Amount]),
            FILTER(
                ALLSELECTED(Sheet1[Mths]),
                'Sheet1'[Mths]<=_min
            )
    )

     

    Best Regards

    Allan

     

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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

I do not understand your requirement.  How can you have more than 12 months in the column labels?  What does that mean?

  • NT2510's avatar
    NT2510
    Frequent Visitor
    5 years ago

    I have updated file with meaure that shows how Mths column is calculated.