Forum Discussion

Anonymous's avatar
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
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Anonymous ,

     

    If you create the new table using the following syntax:

     

    New table =

SELECTCOLUMNS(
   FirstTable,
   "Column", FirstTable[CalculatedColumn])
MFelix's avatar
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's avatar
    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's avatar
      MFelix
      Super User
      4 years ago

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