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

 

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!