Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
How do i calculate sum of three rows for each rows for exampple TableA(ColumnA+ColumnB+Column C) in New Calculated Column D i want to show the sum like given below? Please help!
I am getting the same values for all the rows? I want the result as Column D which is total of col a, b and c.
A B C D
1 1 0 2 ( Sum of A+B+C as 1+1+0)
0 1 0 1
1 1 1 3
Solved! Go to Solution.
Just try like below.
Column D = TableA[A] + TableA[B] + TableA[C]
Best Regards,
Herbert
Yeah that was pretty easy like this..it did work !
If you have got your problem solved, you could mark the right answer as solution to close this thread.
Best Regards,
Herbert
hi @asta
In a Calculated Column:
SumABC = CALCULATE(SUMX(Tabla1,Tabla1[A]+Tabla1[B]+Tabla1[C]))
Hi @asta
Try the folliwng using sumx to iterate over each row.
ColumnD=sumx(Yourtable, (cola+colb+colc))
If this works please accept this as solution and also give KUDOS.
Cheers
CheenuSing
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |