Previous month make all month date that start with "01/01" zero

[Anonymous]

Hi Experts

How would you amend the following messure to make all those month that are 01/01 irrespective of year return zero value as opposed to the previous month value.

Meaure =

PREVIOUSMonth =

IF(CALCULATE(SUM(Orders[Sales]),

        PREVIOUSMONTH(Orders[DDate]))=01/01,0,CALCULATE(SUM(Orders[Sales]),

        PREVIOUSMONTH(Orders[DDate])))

Not working

[v-yalanwu-msft]

Hi, @Anonymous ;

Try it.

PREVIOUSMonth =
IF (
    MONTH ( Orders[DDate] ) = 1
        && DAY ( Orders[DDate] ) = 1,
    0,
    CALCULATE ( SUM ( Orders[Sales] ), PREVIOUSMONTH ( Orders[DDate] ) )
)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Hi Team Yalan is the above a messure or calculated column measure

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

If it is measure,

PREVIOUSMonth =
IF (
    MONTH (max( Orders[DDate]) ) = 1
        && DAY ( max( Orders[DDate]) ) = 1,
    0,
    CALCULATE ( SUM ( Orders[Sales] ), PREVIOUSMONTH ( Orders[DDate] ) )
)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.