Calculate difference between two rows of a measure

[Anonymous]

Hello brilliant community,

I need help with dax to calculate difference between two rows of a measure. Following is a snapshot of my report:

I need a measure for following:

Additional clients/month = active clients accumalative in current month - active clients accumalative in previous month

Attached is my PBI: https://1drv.ms/u/s!Ag919_pO_UKrfqo40LZG9az7zU4?e=qA8erh

Many thanks in advance,

Meena

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description,

You can create measure  ‘Additional clients/month’ as follows.

Active Clients accumulative in current month =

VAR runtott =

    CALCULATE (

        COUNT ( Active_Clients[PTNT_ID] ),

        FILTER (

            ALL ( Active_Clients ),

            Active_Clients[CREATED] <= MAX ( Datedim[Date] )

        )

    )

RETURN

    IF ( MAX ( Datedim[Date] ) <= TODAY () + 30, runtott, BLANK () )

Additional clients/month = COUNT ( Active_Clients[PTNT_ID] )+0

Result:

Best Regards,

Allan

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