Forum Discussion
SUM different row
Hi, I'm a beginner in Power BI and I have (I think?) a simple question: I have currently this table (Total is a calculated column) Col1 Value Total A1 100 A2 200 B1 30...
Hi,
Sorry for the late reply, I was in vacation.
I'm not sure if this is the right method by the admin to mark a reply as solved, that's definetly NOT the solution that I was looking for. Having admin rights doesn't mean you can do whatever you want...
The right way that I did is:
1) Pivot those rows into columns in Power BI Queries with language M.
2) Create a calculated column to sum up the new pivoted columns.
3) Unpivot those columns into rows.
This wroked great !
Quick question, do you want the summed up data listed in the table itself or during runtime in a visual?