Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have the following calculated table:
I've been trying to add to that table a calculated column that runs a cumulative count of the repeating dates from the date column ([Data]) which should (obviously) reset back to 1 every time a new date comes by.
The closest I could get was with the code below, but it still does not produce the results I want, which I hardcoded in red for better understanding of what I really need.
Any help on this one is greatly appreciated!
Solved! Go to Solution.
This code suggested by another user on Stack Overflow did the trick for me:
Cumul Count Date =
ROWNUMBER(
ALLSELECTED(
Tbl[Data],
Tbl[Símbolo],
Tbl[Net result]
),
ORDERBY( Tbl[Data], ASC ),
DEFAULT,
PARTITIONBY( Tbl[Data] )
)
This code suggested by another user on Stack Overflow did the trick for me:
Cumul Count Date =
ROWNUMBER(
ALLSELECTED(
Tbl[Data],
Tbl[Símbolo],
Tbl[Net result]
),
ORDERBY( Tbl[Data], ASC ),
DEFAULT,
PARTITIONBY( Tbl[Data] )
)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |