Solved: sum values with the last date (month) - Page 2

Twister8 · ‎11-07-2016

hello everyone,

I am new in PB and DAX, I need calculate the sum of values from the last month with data on my database, for example:

month values

2016-1 1

2016-2 5

2016-3 10

So I need return the 20 in my result.

Twister8 · ‎11-16-2016

HI,

Tks everybody for answers...

I solved:

LastMonth = IF(YEAR(TODAY())= YEAR('Fact'[Date]) && MONTH(TODAY())-1 = MONTH('Fact'[Date]);1;BLANK())

Mymeasure = CALCULATE(SUM('Fact'[Value]);'Fact'[LatMonth] =1)

sum values with the last date (month)