Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to Solution.
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
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