DAX for count item from previous period

[omegaboost]

Dear All,

How to count the number of "aaa" from the previous period? For example, in period 2 the number of "aaa" is 3 and the thing to look for is the number of "aaa" in the previous period, namely period 1.

What is the DAX formula for this condition?

Thanks

Kode	Period
aaa	1
aaa	1
aaa	2
aaa	2
aaa	2
aaa	3

[omegaboost · Accepted solution]

Dear annonymous1999,

Thank you for your reply..and it's work.

[eliasayyy]

hello use this measure

previous count = 
CALCULATE(
    [Count of Period] ,
    'Table'[Period] = MAX('Table'[Period]) - 1)