The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi Team,
How I can find a weighted average in power bi , for eg
Customer ID | Account Name | Source tag | Profit |
8CUST7O36 | A | 124 | 2456 |
8CUO9XHAS | B | 124 | 35415 |
8CU7Y6683 | c | 126 | 24512 |
8CUY5NJ85 | d | 234 | 25201 |
8CUCWH5Q3 | e | 124 | 254 |
8CU96TBDF | f | 126 | 25421 |
8CUMQV533 | g | 234 | 1454 |
Solved! Go to Solution.
Hi @arvindyadav ,
I have a little confused about your expected output.
It seems that you want to calculate the weighted average, please refer to the similar threads firstly.
https://community.powerbi.com/t5/Desktop/Weighted-Average/td-p/177895
https://community.powerbi.com/t5/Desktop/weighted-average/td-p/347462
If you still need help, please share your desired output based on your data sample so that we could help further on it.
Best Regards,
Cherry
Hi @arvindyadav ,
I have a little confused about your expected output.
It seems that you want to calculate the weighted average, please refer to the similar threads firstly.
https://community.powerbi.com/t5/Desktop/Weighted-Average/td-p/177895
https://community.powerbi.com/t5/Desktop/weighted-average/td-p/347462
If you still need help, please share your desired output based on your data sample so that we could help further on it.
Best Regards,
Cherry
User | Count |
---|---|
159 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
157 | |
137 | |
131 | |
81 | |
61 |