Forum Discussion

DanJaques's avatar
DanJaques
Regular Visitor
8 years ago
Solved

Sum by Month

Hello Everybody! I have this table and I want create one measure who SUM the column VALUE by month.  DATA VALUE 10/01/2016 10 10/02/2016 10 11/01/2016 20 11/02/2016 20 12/03/...
Need Help
Tutorial Requests
  • DanJaques's avatar
    DanJaques
    8 years ago

    I solve it

    Measure = CALCULATE(SUM(Sheet1[Value]);FILTER(ALL(Sheet1);Sheet1[Value]<=MAX(Sheet1[Value])))

     

     

DanJaques's avatar
DanJaques
Regular Visitor
8 years ago

All the number of my days per month are equals, so i'm trying do something like this:

SUM IF (FITLER ALL sheet[data].[month] < MAX (sheet[data].[month])

DanJaques's avatar
DanJaques
Regular Visitor
8 years ago

I solve it

Measure = CALCULATE(SUM(Sheet1[Value]);FILTER(ALL(Sheet1);Sheet1[Value]<=MAX(Sheet1[Value])))