Forum Discussion

Chrism123's avatar
Chrism123
Frequent Visitor
8 years ago
Solved

Last date Previous Month

Hi,   I am trying to find a way to calculate the sum of a value for the last day of the previous month.   For example: If I filter for 31.10.2017 the measure should return the values of 30.09.201...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Chrism123

     

    May be this one

     

    =
CALCULATE (
    SUM ( Table1[Amount] ),
    LASTDATE ( PREVIOUSMONTH ( Kalender[Date] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Chrism123

 

I think this should work

 

CALCULATE (
    [Sales EUR FX],
    LASTDATE ( PREVIOUSMONTH ( Kalender[Date] ) )
)
Chrism123's avatar
Chrism123
Frequent Visitor
8 years ago

very good, thanks. I didn't know that it was possible to use calculate like this.