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 |
Go to Solution.
View solution in original post
Actually it was as easy as that. For some reason I thought that it would not work.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021