create multiple columns within the table

Question

Hi, i have 10tables which i need to create 3 calculated columns each - 2 sums and 1 concantenate.

hence in total, i will be creating 30 columns.

anyway to do it faster - i tried "addcolumns" but i always scalar value error.

thanks in advance.

bhaveshpatel · Accepted Answer

There is no faster way than right clicking the table and coping & Pasting formulas to create calculated column. ADDCOLUMNS can be used in DAX Queries to create calculated tables.

Adding more context to your problem can lead us to provide specific answer.

Forum Discussion

create multiple columns within the table

1 Reply

Related content

Create columns group

Create custom column based on multiple rows

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Multiple line and clustered columns chart