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 |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |