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])))

danb's avatar
danb
Icon for Resolver I rankResolver I
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello danb ,

     

    I am trying to accomplish the same thing, however, I do not have an import file, and therefore, cannot create that in power query...or use the EARLIER function as it is not supported for DirectQuery.

     

    Do you have any ideas of how to achieve this?

     

    Thanks!