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

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

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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