Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to Solution.
Dear annonymous1999,
Thank you for your reply..and it's work.
hello use this measure
previous count =
CALCULATE(
[Count of Period] ,
'Table'[Period] = MAX('Table'[Period]) - 1)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |