Solved: create multiple columns within the table

theo · ‎12-04-2016

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 · ‎12-04-2016

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.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

BhaveshPatel · ‎12-04-2016

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.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.