Forum Discussion
Solved
Multiply grouped by filter sum by a fixed value
Hello everybody i'm stuck with a problem i cannot resolve. I have a timesheet with costumers, task, user who did the job and duration of the task measured in hous. like this one: Customer U...
Burner , You can create a new column like this and sum that up
Total cost in table 1 = maxx(filter(Table2, Table2[user] = Table1[user]),Table2[cost]) * Table1[duration in hour]
Burner , You can create a new column like this and sum that up
Total cost in table 1 = maxx(filter(Table2, Table2[user] = Table1[user]),Table2[cost]) * Table1[duration in hour]
