Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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] )
)
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |