Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In grand total, Am getting 0 or 1 based on the total offshore and onshore houres. But I need to sum up values from each row. Please help.
Month | Onshore | Offshore | SUM | AVG |
Jan | 123 | 123 | 1.0 | 1.0 |
Feb | 321 | 198 | 1.6 | 1.6 |
Mar | 445 | 124 | 3.6 | 3.6 |
Apr | 567 | 122 | 4.6 | 4.6 |
Total | 1456 | 567 | 2.5 | 2.7 |
Hi @mlsx4 ,
In grand total, Am getting 0 or 1 based on the total offshore and onshore houres. But I need to sum up values from each row. Please help.
Hi @SonaSinghA
How are you doing the table? Formulas are working right for me:
SUM_Col = SUMX(MyTable,DIVIDE(MyTable[Onshore],MyTable[Offshore],0))
AVG_Col = AVERAGEX(MyTable,DIVIDE(MyTable[Onshore],MyTable[Offshore],0))
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |