Hi
Could anyone perhaps direct me on the correct expression for what I want to achieve below?
Solved! Go to 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 .
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |