Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 sum with the number in table 2 on the record whichs has John's name, in this exemple 35/5.
Powerbi gives an error that says values from table 2 has to be a sum, max or minimum value (aggregation)
How can I use the value which is found in John's record in table 2?
Solved! Go to Solution.
Try like
divide(sum(Table1[Hour]), MAx(Table2[Hour]))
Try like
divide(sum(Table1[Hour]), MAx(Table2[Hour]))
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?
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |