If month help

[Anonymous]

I have data for which i created a measure that calculates the difference in revenue per month. What i want though is to exclude one month from that calculation. How do i do that? I tried some if statements but i failed.

[v-shex-msft · Accepted solution]

HI @Anonymous ,

You can try to use the following measures formula to compare with current mont revenue and previous month revenue:

Meaasure =
VAR currDate =
    MAX ( Table[Date] )
VAR previous =
    DATE ( YEAR ( currDate ), MONTH ( currDate ) - 1, DAY ( currDate ) )
RETURN
    SUM ( Table[revenue] )
        - CALCULATE (
            SUM ( Table[revenue] ),
            FILTER (
                ALLSELECTED ( Table ),
                YEAR ( [Date] ) = YEAR ( Previous )
                    && MONTH ( [Date] ) = MONTH ( previous )
            )
        )

Regards,

Xiaoxin Sheng

[Anonymous]

So bacisally i have calculated the differences per month from january to december with this measure : SUM (revenue)-CALCULATE(SUM(revenue),PREVIOUSMONTH (date).

Now i just want to exclude september from this calculation. 

Any ideas?