Running Total Last Year

[Anonymous]

Hello everyone,

I created a measure that will compute the total count as per last year, however, it is showing blank value.

Can anybody help me? I need to get the total last year value.

ActiveAccountsLastYear =

CALCULATE(COUNT(Account[accountid]), Account[statecode] = 0, USERELATIONSHIP(Account[createdon], 'Date dimension'[Date]),

FILTER(ALL('Date dimension'),

'Date dimension'[Date] <= (DATEADD('Date dimension'[Date],-12,MONTH))))

[v-chuncz-msft]

@Anonymous ,

Try using the functions below instead of DATEADD.

• DATE
• YEAR
• MONTH