Forum Discussion
Solved
Weighted average
Hello, I need to weight a variable by another in Power BI. I have tried several formulae that I have found online to no avail. The results are incorrect when I compare them with the SPSS output t...
I found a solution for this problem: SPSS will automatically not include cases where there isn't data for either the value or the weight you are using but powerbi doesn't do that. You have to go in and manually remove any of those data points in the dataset so that the values return what you get in SPSS.
Here is a small sample of the data:
| Total number of new college graduate hires at your organization (or unit) | Percentage of your new full-time entry-level college hires typically come from interviews initially conducted on-campus |
| 242.00 | 80.00 |
| 2214.00 | |
| 1613.00 | |
| 371.00 | 60.00 |
| 382.00 | |
| 0.00 | 15.00 |
| 120.00 | |
| 400.00 | 15.00 |
| 104.00 | 40.00 |
- Greg_Deckler
Community Champion
mabelsabogal So what are the results that you would expect from that sample?
