Forum Discussion

jamieham's avatar
jamieham
Icon for Helper II rankHelper II
6 years ago
Solved

Creating New column by copying specific data from one column to another

I'm trying to create new colums for Carry Metres and Kick Metres based on a data set that looks like below. I need to copy the Carry Metres into a seperate column and the same with the Kick Metres an...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , jamieham 

    Try to create calculated column as below:

     

    Carry_Metres = IF(Table_basic[Action]="Carry",Table_basic[Metres],BLANK())
    Kick_Metres = IF(Table_basic[Action]="Kick",Table_basic[Metres],BLANK())

     

     

    For more details,please refer to the sample file.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jamieham 

 

I would go to Power Query editor

Select these two columns

On the  transform menu --> Pivot(Hope you have other columns in this table otherwise it will error out)