Add calculated column as Table

[Anonymous]

Hi All,

I have created a calculated column (Column1) in Table1 and want to create a new table (Table2) using Column1.

Can some one please suggest how we can achieve this.

Thank you

[MFelix · Accepted solution]

Hi @Anonymous ,

If you create the new table using the following syntax:

New table =

SELECTCOLUMNS(
   FirstTable,
   "Column", FirstTable[CalculatedColumn])

[Anonymous]

Thank you @MFelix  your solution worked but I see duplicates in the data so I tried using the below syntax

New Table =

Distinct(FirstTable[CalculatedColumn])

[MFelix]

Don't forget to mark the correct answer so it can help others.

[Pragati11]

Hi @Anonymous ,

You need to add more details to your question to get answered. Refer following link:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati