topic Re: dax previousmonth in Developer

dax previousmonth

Janaki — Thu, 01 Jun 2017 23:26:29 GMT

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,

Re: dax previousmonth

Eric_Zhang — Fri, 02 Jun 2017 02:29:29 GMT

@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] )
    )
)

Re: dax previousmonth

Janaki — Fri, 02 Jun 2017 16:23:04 GMT

Hi,

Thank you. The currentvalue that I am using is a measure. Would you have a alternate suggestion?

Re: dax previousmonth

Eric_Zhang — Sat, 03 Jun 2017 01:18:00 GMT

@Janaki wrote:

Hi,

Thank you. The currentvalue that I am using is a measure. Would you have a alternate suggestion?

@Janaki

Then just try

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