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.
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
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |