Forum Discussion

Regular Visitor

4 years ago

Solved

undefined

Hello all, I have been trying to count how many people have joined in the previous month, but I am not getting a result for every month. I have the values only for the months which end in...

Dashboards

tamerj1

4 years ago

Hi MadaM

You may try

Prev Month =
VAR PreviousDate =
    EOMONTH ( MAX ( 'Monthly Joined'[Date Joined] ), -1 )
RETURN
    CALCULATE (
        SUM ( 'Monthly Joined'[ContJoined] ),
        'Monthly Joined'[Date Joined] = PreviousDate
    )

tamerj1

Community Champion

4 years ago

Hi MadaM

You may try

Prev Month =
VAR PreviousDate =
    EOMONTH ( MAX ( 'Monthly Joined'[Date Joined] ), -1 )
RETURN
    CALCULATE (
        SUM ( 'Monthly Joined'[ContJoined] ),
        'Monthly Joined'[Date Joined] = PreviousDate
    )