Multiple employees average percentage weekly, monthly, quarterly
I have 10 employees and need to calculate their average percentage weekly, monthly and quarterly. For Example: Joe Column/row C1 Sam Column/row D1 Greg Column/row E1 1st week row 2 2nd week row 2 3rd week row 4 4th week row 5 This will continue to row 52 I have a another column January Column T Feburary Column U March Column V Quarterly Column W Joe =average(C2:C5) on cell T2, =average(C6:C9) U2 =average(C10:13) V2 This gives me the percentage for weeks 1-4 month of January How do I create a formula for Sam (D2:D5) in T3 and Greg (E2:E5) in T4 and for the rest of the multiple employees without having to manually enter the formula for each cell. This we’ll be for the entire year, 52 weeks for each employee. I tried everything to copy paste formula, drag cell, etc but gives me the same results of only Cell C2:C5, C6:C9, etc. Any help will be great. I have been researching testing and nothing is working. TIA AverageAsker arvindsingh802
Avarage of opened tickets Aging
Hello All, I am having a difficulty getting average days count in a month depending on number of cases and the age days of a case/ticket. Below is an example just to give some information. if the problem/ticket/case is Opened on Jan 01, 2021, and it was closed on May 15 2021 In the month of Jan Aging(age) of that ticket is 30 days and in Feb it is 58 days (30 +28) and in Mar 89 (58+31) in April (119) (89+ 30) at the end it should show the average of tickets aging in each month. If anyone knows how we can get this, please let me know and thanks for the help in advanceGet the average of a column value based on total count of values in ID column
Hi, In a table i have column called "Object" which runs multiple times in a day and that runtime is captured in "StartTime" & "EndTime" columns, and the difference between the start and end time is captured in the "Duration" Column. Each object will be having multiple runid's which is captured in "RunID" column which is a unique value. For eg: Object AAA has two runid's called "111,222" and Object BBB has one runid called "333". Now i would like to get the average of each duration by count of that particular runid which is captured in "New Duration" column. For eg: The count of 111 runid is '10'. so for all those durations with runid 111 should be divided by the 10. The count of 222 runid is '6'. so for all those durations with runid 222 should be divided by the 6. The count of 333 runid is '8'. so for all those durations with runid 333 should be divided by the 8. Sample screenshot for above query: So since my Duration is "10" and total count of runid (111) is 10. So 10/10=1 that is my newduration.Similarly for all durations with runid's 111 should be divided bt 10. How to achieve this using DAX query?? I am connecting to this table in powerbi via SQL direct query mode. Thanks.I want to Average multiple columns but ignoring any zeroes or blanks
Hello Everyone, I am looking for a solution as shown in the table above in PowerBI, I want to create a new column that prints average of these 4 columns but only if they have a non-zero/non blank value. I.e. the answer for first row should not be ((0+0+5+0)/4) instead just (5/1) since rest of the columns are empty. Any replies would be much appreciated, thanks.
