Forum Discussion

stark1687's avatar
stark1687
Regular Visitor
8 years ago
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...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution file from here.  Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Paste the column titles with your data.  How does one know what is the info in that column without a title?

  • stark1687's avatar
    stark1687
    Regular Visitor
    8 years ago

    Sorry didnt realize I missed the headers

     

    ProjectCostEventVendor Code
    1967 $  3,694,483.24CI41371
    2604 $  2,396,125.21CI37608
    2605 $  1,219,674.86CI41371
    3442 $      776,005.65CI41371
    3457 $      883,514.22CI3394
    3458 $  1,273,172.80CI3394
    3462 $  1,606,554.29CI38528
    3475 $  1,299,846.38CI3394
    4153 $      512,749.13CI41371