Adding New Custom Column

[magtuto]

Hello All,

If I have the following table in Power BI which I am using as my data source (say in an Excel format) with the following structure as per below.

| Name |  Basketball |  Tennis | Hockey |

| John   |   3              |  3          |  2          |

| Chris  |   3              |  3          |  3          |

| Pedro | 5                | 5           | 4           |

I have done numerous visualisations, various measures and calculalted columns then I decided I need another column to the table (Gender);

1.  Can you add another column after initial data source attchment?

2. How is this done?

Gender | Name |  Basketball |  Tennis | Hockey |

Male     | John   |   3              |  3          |  2          |

Female | Chris  |   3              |  3          |  3          |

Male    | Pedro | 5                | 5           | 4           |

[GarryFarrell · Accepted solution]

Hi,

You should be able to add the extra column in your excel source and then refresh and it should be available.

Otherwise you can add a new table in Power BI by using add data. Then you will need to join the table.

[magtuto]

Gary,

Actually it was as easy as that.  For some reason I thought that it would not work.

Thanks