Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I try to Multiply 2 Columns of 2 differents table.
one is a Personal reference table and the other is the hours done by project
I create a relation between the two table with the both column name
Solved! Go to Solution.
It's ok the summurize must be done on Name and it's ok
Thank you very much for your help
Ideally for mutliplication you should use
Sum(A*B)
When that is not possible use the row context
Costs =
sumx(summarize(Project, project[ID],"_dat",SUM('DATA'[Hours done]) ,"_hrs",SUM('Personel'[Hourly rate])),[_dat]*[_hrs])
if you need more help make me @
Appreciate your Kudos.
Hello,
I try your code but I have exactly the same result
My both table are DATA and Personel
It's ok the summurize must be done on Name and it's ok
Thank you very much for your help
@Vincent_Jaquet , that is what you could have found best. As I am not aware best of your data model. Kudos !!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |