Forum Discussion
Solved
Using a value from table 2 to makes a calculation
Asked before now with an example. In PowerBI I like to make a calculation with numbers from 2 tables. 1. sum the hours of a person from table 1 (John has 30 + 5 = 35 hours) 2. divide this...
divide(sum(Table1[Hour]), MAx(Table2[Hour]))
Using this formula will use the highest value form table 2? Not the value of John's record I suppose?