Calculating sum for large number of columns

[GetJam95]

Hi, I've been trying to create a custom column to calculate the sum for each row across a large number of columns (~200). I've tried going down the SUMX route but inputting each individual column just isn't practical. This is something I could do in 5 seconds in Excel using SUM but I'm getting absolutely stumped in Power BI. Is there a way for me to do this without manually inputting each individual column to be summed?

[amitchandak]

@GetJam95 , I doubt such a way.

Unpivot is one way, but that will increase data by 200 times

https://radacad.com/pivot-and-unpivot-with-power-bi