Forum Discussion
Easy Calculation
Hi @ all,
I would like to calculate the following: "Workload Person/Activity"
Person Activity Workload Workload Person/Activity
| A | 1 | 50% | 70% |
| A | 1 | 20% | 70% |
| A | 2 | 30% | 30% |
| B | 1 | 10% | 20% |
| B | 1 | 10% | 20% |
| B | 2 | 80% | 80% |
This should be a simple DAX formula but I just can't figure it out :)
new column = sumx(filter(TableName;earlier([Person])=[Person]&&earlier([Activity])=[Activity]);[Workload])
try this
2 Replies
Replies have been turned off for this discussion
new column = sumx(filter(TableName;earlier([Person])=[Person]&&earlier([Activity])=[Activity]);[Workload])
try this