Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated Column of Sum per Month

Hello!   I have a calculation to complete that requires a sum of the current month. Note, I need this to be done with a calculated DAX column, not a measure unfortunately! My calculation is pretty ...
Need Help
  • danb's avatar
    danb
    8 years ago

    Anonymous

    Try this calculated column:

     

    TotalPerMonth = CALCULATE(SUM(Table1[Amount]),FILTER(Table1,Table1[Date] = EARLIER(Table1[Date])))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey danb!

 

The code you posted creates an error "EARLIER/EARLIEST refers to an earlier row context which doesn't exist."

 

Any Ideas?

danb's avatar
danb
Icon for Resolver I rankResolver I
8 years ago

Anonymous

Enter in the formula as a "New Column" and not a "New Measure"

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    Yup, I am entering it as a new column

    • danb's avatar
      danb
      Icon for Resolver I rankResolver I
      8 years ago

      Anonymous - it appears that you have some type of error occuring after the "earlier" function. Please see my screenshot below. I have the same column in with the May/June data and it is not tripping the error. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Yes today is a monday, I was adding it as a measure. :smileyfrustrated:

         

        Your function works, thank you

         

        I had to adjust it a bit however: 

         

        I made a new column format(table1[date] , "yyyymm")

         

        then filtered using that new column.

         

        By filtering by date, it gives the sum/ per day instead of per month. big thanks though!