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 D1 1 0 2 ( Sum of A+B+C as 1+1+0)0 1 0 11 1 1 3
Go to Solution.
Just try like below.
Column D =
TableA[A] + TableA[B] + TableA[C]
View solution in original post
Try the folliwng using sumx to iterate over each row.
If this works please accept this as solution and also give KUDOS.
In a Calculated Column:
SumABC = CALCULATE(SUMX(Tabla1,Tabla1[A]+Tabla1[B]+Tabla1[C]))
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.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021