cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Need Help: Average the % gas fills by each Department.

Hello.

I am trying to calculate an average fill percentage for each area for gas deliveries.  I cannot seem to find a solution to this anywhere.  I would appreciate any guidance on this.  Screenshot below. Thank you!!

3 REPLIES 3
Frequent Visitor

Hi everyone.

I am trying to calculate an average fill percentage for each area's gas deliveries.  I cannot seem to find a solution to this anywhere.  I would appreciate any guidance on this.  Data table is below.  Please let me know if there is additional information needed.  Thank you!!

1.  Show average %Filled broken down by AREA in a time period.
2.  Be able to show all of the TOTAL % FILLS that are below the Target of 60%.  Again, broken down by area.

 Area Account No Submission No Sequence by Account no FillDate Assigned Fill Frequency (Days) Frequency Variance (Days) Total Tanks Capacity Total Quantity Delivered Total % Filled Fill Target % Fill Target Variance (% points) E101 8018879 SN4177028 0 1/20/2022 35 -35 750 373 50% 60% -10 E101 8018879 SN4198336 1 2/12/2022 35 -12 750 399 53% 60% -7 E101 8018879 SN4228695 2 3/16/2022 35 -3 750 371 49% 60% -11 E101 8018879 SN4255589 3 4/13/2022 35 -7 750 205 27% 60% -33 C101 8023107 SN4297848 0 5/26/2022 98 -98 12000 2005 17% 60% -43 C101 8023107 SN4357194 1 7/27/2022 98 -36 12000 2274 19% 60% -41 W101 8023527 SN4177421 0 1/20/2022 21 -21 6600 3972 60% 60% 0 W101 8023527 SN4187176 1 1/31/2022 21 -10 6600 2458 37% 60% -23 W101 8023527 SN4206944 2 2/22/2022 21 1 6600 4040 61% 60% 1 E102 8025005 SN4206612 0 2/21/2022 28 -28 4000 3065 77% 60% 17 E102 8025005 SN4318232 1 6/16/2022 28 87 4000 4260 107% 60% 47

Super User

hi @FOZZY

you may get a solution quicker if you paste your sample data as text.

Frequent Visitor

Sorry for the delay in response.  Below is a sample of the data.  What I am looking to do in visuals is
1.  Show average percent fill amount per area in a time period determined by a slicer.
2.  Be able to show all of the Total % fills that are below the Target %.  Broken down by area.

 Area Account No Submission No Sequence by Account no FillDate Assigned Fill Frequency (Days) Frequency Variance (Days) Total Tanks Capacity Total Quantity Delivered Total % Filled Fill Target % Fill Target Variance (% points) E101 8018879 SN4177028 0 1/20/2022 35 -35 750 373 50% 60% -10 E101 8018879 SN4198336 1 2/12/2022 35 -12 750 399 53% 60% -7 E101 8018879 SN4228695 2 3/16/2022 35 -3 750 371 49% 60% -11 E101 8018879 SN4255589 3 4/13/2022 35 -7 750 205 27% 60% -33 C101 8023107 SN4297848 0 5/26/2022 98 -98 12000 2005 17% 60% -43 C101 8023107 SN4357194 1 7/27/2022 98 -36 12000 2274 19% 60% -41 W101 8023527 SN4177421 0 1/20/2022 21 -21 6600 3972 60% 60% 0 W101 8023527 SN4187176 1 1/31/2022 21 -10 6600 2458 37% 60% -23 W101 8023527 SN4206944 2 2/22/2022 21 1 6600 4040 61% 60% 1 E102 8025005 SN4206612 0 2/21/2022 28 -28 4000 3065 77% 60% 17 E102 8025005 SN4318232 1 6/16/2022 28 87 4000 4260 107% 60% 47

Announcements

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors