Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Add calculated column as Table

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
4 years ago
Hi Anonymous ,

If you create the new table using the following syntax:

New table = SELECTCOLUMNS( FirstTable, "Column", FirstTable[CalculatedColumn])

4 Replies

MFelix
Super User
4 years ago
Hi Anonymous ,

If you create the new table using the following syntax:

New table = SELECTCOLUMNS( FirstTable, "Column", FirstTable[CalculatedColumn])
- Anonymous
  Not applicable
  4 years ago
  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
    Super User
    4 years ago
    Don't forget to mark the correct answer so it can help others.
Pragati11
Super User
4 years ago
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

Related content