Sum specific range in a row

[Cellardoor]

Dear all.

Just trying to transpose from excel to powerbi :).

Lets imagine the following matrix

Columns:     A   B  C   D

Rows     1    20 40 60

              2    5   10 20

              3    1   2   3

I want column D to sum the A B C values. In excel would be = sum (table1[@[A]:[C]). The results should be: row 1 = 120, row 2= 35, row 3 =6

I imported the data from excel. I should execute this formula in my excel table and then import from powerbi or just import the raw data to powerbi and  then execute the formula? or its the same?

Eitherway, can you help me with this formula?

Thank you

Hope it gets clear. Thank you

[vanessafvg · Accepted solution]

Just create a measure

measure = (sum(col1) + sum(colb)) etc.

[Cellardoor]

It seems im a beginner on this...

Oh...wait...

Thank you