Forum Discussion
Solved
Total different columns rows
Hello! I am looking to add up a handful of columns of one row into a new measure/column
ex) How would I made a NEW COLUMN that adds up column A, B and C in each row?
| Column A | Column B | Column C | NEW COLUMN |
| 5 | 3 | 1 | 5+3+1 |
| 7 | 1 | 6 | 7+1+6 |
Hey nataliesmiy1357 ,
I assume this will get you started on how to create a calculated column: Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn
The DAX will look something llike this:
new column name = 'tablename'[ColumnA]+'tablename'[ColumnB]+'tablename'[ColumnC]Hopefully, this helps to tackle this challge.
Regards,
Tom
1 Reply
Hey nataliesmiy1357 ,
I assume this will get you started on how to create a calculated column: Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn
The DAX will look something llike this:
new column name = 'tablename'[ColumnA]+'tablename'[ColumnB]+'tablename'[ColumnC]Hopefully, this helps to tackle this challge.
Regards,
Tom