Forum Discussion
Counting Units Per Company
Good Day! I have a live excel document that shows how many units were taken per company, with each company divided in to multiple foremans. All I want power bi to do is display how many 'pump & m...
ryan_mayu
Super User
Super Usercould you pls paste the sample data (not the screenshot)?
What's more, what is the expected output? what's the logic of calculation?
Good morning, thank you for the reply.
I am unable to post the data, it says 'The file type (.xlsx) is not supported. How do I post the data properly?
- ryan_mayu
you can directly copy paste the data in the reply like below
column column2 a 1 b 2 c 3 Company Contact 4 Gas Pump&Monitor Total Units Acuren Rob Arsenault 22 2 24 Cart Darren 8 10 18 Cart Bev 6 11 17 Clean Harbors Doug 28 6 34 Clean Harbors Matt 10 5 15 Edmonton Ex Jeff 8 4
12 Edmonton Ex Alanna 6 4 10 Edmonton Ex Greg 5 2 7 Melloy Jerry 3 2 5 Melloy Jason 32 6 38 What I would like is to be able to count how many '4 Gas' and 'Pump' and Monitors are issued per 'Company'. In a Table Visual like below:
Company 4 Gas Pump&Monitor Total Acuren 22 2 24 Cart 14 21 35 Edmonton Ex 19 10 29 Melloy 35 8 43 - ryan_mayu
it looks like the calculation logic is SUM
what's more, why we don't want to show the data of clean harbors?