Forum Discussion
Helper IIsum values with the last date (month)
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)
Community ChampionI created a column like this:
Column = CONCATENATE(YEAR([month]),MONTH([month]))
switched this to a Whole Number format
and then a measure like this:
SumLatest = SUMX(FILTER(LastMonth,[Column]=MAX([Column])),[values])
Twister8Tks for answer :), but isnt working for me :(
What is LastMonth? function? When I type Colum = MAX[Column] I have error because Column isnt the Date column
I am try use:
LastMonth= CALCULATE(SUM('MYtable'[Colum With Value]); PREVIOUSMONTH('MYTableTIME'[Date]))
However when I typed in my expression i can't see the result, because i dont have a total
When I use this:
LastMonth = CALCULATE([Colum With Value];DATEADD(MYTable[Date]; -1; MONTH))
the total is all months of all years, i need just last month, in my example month 03, its possible filter the actual year?
- Greg_Deckler
LastMonth is my table name.
- Twister8
Tks.
I need show just 1, because last month its october, but its wrong