Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
Gary,
Actually it was as easy as that. For some reason I thought that it would not work.
Thanks
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |