Measure incorrect

[analyst85]

Hi, I have a measure that counts the number of users by the date in the past 30 days, then also does the same for the previous month (31-60) and subtracts the 30 day count from the 31-60 count. From counting the raw data it doesn't that this is right, have I wrote it wrong?

# Operations MoM Comparison =

CALCULATE(

    [# Operations],

    FILTER(

        ALL('Dates'[FullDate]),

        'Dates'[FullDate] >= TODAY() - 60 && 'Dates'[FullDate] <= TODAY() - 31

    )

) -

CALCULATE(

    [# Operations],

    FILTER(

        ALL('Dates'[FullDate]),

    'Dates'[FullDate] >= TODAY() - 30 && 'Dates'[FullDate] <= TODAY()

    )

)

[v-yilong-msft · Accepted solution]

Hi @analyst85 ,

I create a table as you mentioned but I have only ten days before.

Also I have a measure.

# Operations = SUM(Dates[Sum])

Then I do some changes on your DAX codes and it will give you the correct result. You can change the "31" to "30".

# Operations MoM Comparison = 
CALCULATE(
    [# Operations],
    FILTER(
        ALL('Dates'[FullDate]),
        'Dates'[FullDate] >= TODAY() - 10 && 'Dates'[FullDate] <= TODAY() - 5
    )
) -
CALCULATE(
    [# Operations],
    FILTER(
        ALL('Dates'[FullDate]),
    'Dates'[FullDate] >= TODAY() - 5 && 'Dates'[FullDate] <= TODAY()
    )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kishore_KVN]

Hello @analyst85 ,

Can you please try below measure:

# Operations MoM Comparison =
CALCULATE(
    [# Operations],
    FILTER(
        ALL('Dates'[FullDate]),
        'Dates'[FullDate] > TODAY() - 61 && 'Dates'[FullDate] <= TODAY() - 30
    )
) -
CALCULATE(
    [# Operations],
    FILTER(
        ALL('Dates'[FullDate]),
        'Dates'[FullDate] >= TODAY() - 29 && 'Dates'[FullDate] <= TODAY()
    )
)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!