Forum Discussion

Userpath77's avatar
Userpath77
Icon for Helper II rankHelper II
2 years ago

Help with Running Totals

Hi All    I have a table called month_vals which just has 12 months (field is called Month Short) and an FY Order column which numbers the months starting with Oct as 1, Nov as 2, etc.. It serves a...
"Need Help"
Userpath77's avatar
Userpath77
Icon for Helper II rankHelper II
2 years ago

Thanks Dangar. When I enter yoru formula, I get a message that multiple arguments are not allowed in the ALLSELECTED function when the first argument is a table reference.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Userpath77 

 

In above code update allselected 

 

CALCULATE(

    SUM('Commitment_Docs'[Commitment Amt]),

    FILTER( 

      allselected(

                  'Month_Vals'[FY Order],

                  'Month_Vals'[Month Short]

      ),

     'Month_Vals'[FY Order] <= MAX('Month_Vals'[FY Order])

     && 'Month_Vals'[Month Short] < MAX('Month_Vals'[Month Short])

   ) 

)