topic Calculating a weighted average in Developer
https://community.powerbi.com/t5/Developer/Calculating-a-weighted-average/m-p/1403150#M25948
<P>Hi</P><P>I have a SharePoint list with 5 number columns (item1, item2, item3, item4, item5) and a category choice column with values category 1 and category 1 and a people column.</P><P> </P><P>I would like to use Power BI desktop to build a graph that shows the sum of item1, the sum of item2, the sum of item3, the sum of item4, and the sum of item5. I was able to achieve this using a pie graph and also a stacked column chart. How can I build a bar chart that shows the sum of each item on a separate bar for a side-by-side comparison? Finally, I would like to show a data-table that calculates a weighted average of each number column i.e for item1, item2, item3, item 4 and item5. The weighted average formula is= 0.7*category1 score of Item + 0.3*category2 score of item</P><P> </P><P> </P><P> </P><P>How can I achieve this using power BI desktop? I am using a SharePoint 2019 list. Can anyone please list the steps to achieve this?</P><P> </P><P>Thanks in advance,</P>Wed, 30 Sep 2020 01:52:53 GMTrythm2020-09-30T01:52:53ZCalculating a weighted average
https://community.powerbi.com/t5/Developer/Calculating-a-weighted-average/m-p/1403150#M25948
<P>Hi</P><P>I have a SharePoint list with 5 number columns (item1, item2, item3, item4, item5) and a category choice column with values category 1 and category 1 and a people column.</P><P> </P><P>I would like to use Power BI desktop to build a graph that shows the sum of item1, the sum of item2, the sum of item3, the sum of item4, and the sum of item5. I was able to achieve this using a pie graph and also a stacked column chart. How can I build a bar chart that shows the sum of each item on a separate bar for a side-by-side comparison? Finally, I would like to show a data-table that calculates a weighted average of each number column i.e for item1, item2, item3, item 4 and item5. The weighted average formula is= 0.7*category1 score of Item + 0.3*category2 score of item</P><P> </P><P> </P><P> </P><P>How can I achieve this using power BI desktop? I am using a SharePoint 2019 list. Can anyone please list the steps to achieve this?</P><P> </P><P>Thanks in advance,</P>Wed, 30 Sep 2020 01:52:53 GMThttps://community.powerbi.com/t5/Developer/Calculating-a-weighted-average/m-p/1403150#M25948rythm2020-09-30T01:52:53Z