dax previousmonth

---

Janaki wrote:

Hi,

 

I am trying use PREVIOUSMONTH to get the previous month value. My data looks like this

 

 

I calculated previous from current value using PREVIOUSMONTH, but i get one extra month March 2017.

Previousvalue =
CALCULATE(
'xyz'[CurrentValue],
PREVIOUSMONTH('xyz'[ReportDate].[Date]))

 

Can someone help me understand why am i getting March, though my date column stops at feb 2017?  Thank you,

---

Janaki

It seems by design. If you don't like it, try to apply some tricks as

Previousvalue =
IF (
    ISBLANK ( MAX ( xyz[ReportDate] ) ),
    BLANK (),
    CALCULATE (
        SUM ( 'xyz'[CurrentValue] ),
        PREVIOUSMONTH ( dimdate[Date].[Date] )
    )
)