Forum Discussion
Sum of Multiply Column from Different Table
Hey, so I have three tables called Project, Timesheet, and Parameter. The Project has one to many connection with Timesheet. I need to have a measure that calculate the sum of the multiplication of Timesheet[allocation] and Parameter[numbervalue] for each project. However, I can't seem to achieve that using SUM or SUMX. Is there any way I could achieve that? Thank you in advance!
Anonymous , selected value of Parameter[numbervalue] or min/max value
If selectedvalue then
a new measure
measure =
sumx(Timesheet, Timesheet[allocation]* selectedvalues(Parameter[numbervalue]) )
If with Min or max or with any join logic a new column
new column =
Timesheet[allocation]*min(Parameter[numbervalue]) // Min or Max or sum
refer if needed
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
1 Reply
- amitchandak
Super User
Anonymous , selected value of Parameter[numbervalue] or min/max value
If selectedvalue then
a new measure
measure =
sumx(Timesheet, Timesheet[allocation]* selectedvalues(Parameter[numbervalue]) )
If with Min or max or with any join logic a new column
new column =
Timesheet[allocation]*min(Parameter[numbervalue]) // Min or Max or sum
refer if needed
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8