Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
leolapa_br
Resolver I
Resolver I

Calculated column with cumulative count of repeating dates

I have the following calculated table:

 

Tbl.png

 

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.

 

Col.png

 

Any help on this one is greatly appreciated!

1 ACCEPTED SOLUTION
leolapa_br
Resolver I
Resolver I

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] ) 
)

View solution in original post

1 REPLY 1
leolapa_br
Resolver I
Resolver I

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] ) 
)

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors