Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If month help

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 stat...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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?