Forum Discussion
Solved
Average by Column then Percent Difference
New PowerBI user here. I have a set of data of project spend and I am trying to get the averages based upon two columns "Event" and "Vendor". Then I want to compare actuals to %difference of...
Hi,
Paste the column titles with your data. How does one know what is the info in that column without a title?
Sorry didnt realize I missed the headers
| Project | Cost | Event | Vendor Code |
| 1967 | $ 3,694,483.24 | CI | 41371 |
| 2604 | $ 2,396,125.21 | CI | 37608 |
| 2605 | $ 1,219,674.86 | CI | 41371 |
| 3442 | $ 776,005.65 | CI | 41371 |
| 3457 | $ 883,514.22 | CI | 3394 |
| 3458 | $ 1,273,172.80 | CI | 3394 |
| 3462 | $ 1,606,554.29 | CI | 38528 |
| 3475 | $ 1,299,846.38 | CI | 3394 |
| 4153 | $ 512,749.13 | CI | 41371 |