Sequential numbering based on dublication of two columns

[Skip2MiLu]

Hi 

Could anyone perhaps direct me on the correct expression for what I want to achieve below?

[dbaum · Accepted solution]

If you're talking about the column's initial value, try something along the lines of:

COUNT(SELECT(Table[User], AND([Workout Day] = [_THISROW].[Workout Day],[Exercise Name] = [_THISROW].[Exercise Name])) + 1

If this is a child table, you might be able to utilize a technique like:

COUNT([Parent ID].[Related Child Rows]) + 1

Additional information in  Serial Numbers, If You Must - Google Cloud Community . 

[Skip2MiLu]

Thanks @dbaum ! The 1st expression is what needed.