Running Total Last Year

Question

Hello everyone,&nbsp;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.&nbsp;ActiveAccountsLastYear = CALCULATE(COUNT(Account[accountid]), Account[statecode] = 0, USERELATIONSHIP(Account[createdon], 'Date dimension'[Date]),FILTER(ALL('Date dimension'),'Date dimension'[Date] &lt;= (DATEADD('Date dimension'[Date],-12,MONTH))))

v-chuncz-msft · Answer

Anonymous&nbsp;,
&nbsp;
Try using the functions below instead of&nbsp;DATEADD.

DATE
YEAR
MONTH

Forum Discussion

Running Total Last Year

1 Reply

Related content

Running Totals

Running total

Waterfall Charts with running totals

Tableau to PowerBI Running Totals Issue

SumX? - cumulative running total