Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
Really appreciated it if you guys can help me.
I want to count how many new products my company have in 2022. Below is an example of my data.
I have tried many calculations but have not yet identified the active one.
| Year | Product |
| 2021 | A |
| 2021 | B |
| 2021 | C |
| 2021 | D |
| 2022 | A |
| 2022 | B |
| 2022 | D |
| 2022 | E |
The final result I want for this sample is one (in 2022 we have one new products "E")
Thank you so much,
Solved! Go to Solution.
Excel worksheet formula is powerful enough
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thank you so muchhhhh
Excel worksheet formula is powerful enough
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 31 | |
| 18 | |
| 12 | |
| 11 |