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.
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.