Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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] )
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
14 | |
13 | |
12 | |
9 |