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"
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Userpath77 

try below

CALCULATE(
    SUM('Commitment_Docs'[Commitment Amt]),
    FILTER( 
      allselected('Month_Vals', 
                  '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])
   ) 
)
  • 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])

         ) 

      )