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.
Need help
I have both the data points in same column so not sure how to get the weighted average. In the below example, i need to find Weighted average for ASA(Seconds) based on Vol. Handled
Skill | Metric | Date | Value |
Tier 1 | Vol. Handled | 09-01-2018 | 100 |
Tier 1 | Vol. Handled | 09-02-2018 | 130 |
Tier 1 | Vol. Handled | 09-03-2018 | 189 |
Tier 1 | Vol. Handled | 09-04-2018 | 90 |
Tier 1 | Vol. Handled | 09-05-2018 | 67 |
Tier 1 | Vol. Handled | 09-06-2018 | 78 |
Tier 1 | Vol. Offered | 09-01-2018 | 110 |
Tier 1 | Vol. Offered | 09-02-2018 | 140 |
Tier 1 | Vol. Offered | 09-03-2018 | 199 |
Tier 1 | Vol. Offered | 09-04-2018 | 100 |
Tier 1 | Vol. Offered | 09-05-2018 | 77 |
Tier 1 | Vol. Offered | 09-06-2018 | 88 |
Tier 1 | ASA(Seconds) | 09-01-2018 | 120 |
Tier 1 | ASA(Seconds) | 09-02-2018 | 140 |
Tier 1 | ASA(Seconds) | 09-03-2018 | 60 |
Tier 1 | ASA(Seconds) | 09-04-2018 | 89 |
Tier 1 | ASA(Seconds) | 09-05-2018 | 98 |
Tier 1 | ASA(Seconds) | 09-06-2018 | 12 |
Tier 2 | Vol. Handled | 09-01-2018 | 130 |
Tier 2 | Vol. Handled | 09-02-2018 | 123 |
Tier 2 | Vol. Handled | 09-03-2018 | 167 |
Tier 2 | Vol. Handled | 09-04-2018 | 89 |
Tier 2 | Vol. Handled | 09-05-2018 | 67 |
Tier 2 | Vol. Handled | 09-06-2018 | 78 |
Tier 1 | Vol. Offered | 09-01-2018 | 140 |
Tier 1 | Vol. Offered | 09-02-2018 | 133 |
Tier 1 | Vol. Offered | 09-03-2018 | 177 |
Tier 1 | Vol. Offered | 09-04-2018 | 99 |
Tier 1 | Vol. Offered | 09-05-2018 | 77 |
Tier 1 | Vol. Offered | 09-06-2018 | 88 |
Tier 2 | ASA(Seconds) | 09-01-2018 | 78 |
Tier 2 | ASA(Seconds) | 09-02-2018 | 98 |
Tier 2 | ASA(Seconds) | 09-03-2018 | 56 |
Tier 2 | ASA(Seconds) | 09-04-2018 | 67 |
Tier 2 | ASA(Seconds) | 09-05-2018 | 108 |
Tier 2 | ASA(Seconds) | 09-06-2018 | 92 |
if u elaborate the formulae it will be helpful to answer
Hi @Anto123,
Please refer to below formula to create a calculated column.
Weighed Average = CALCULATE ( SUM ( Table[Value] ), FILTER ( ALLEXCEPT ( Table, Table[Skill] ), Table[Matric] = "ASA(Seconds)" ) ) / CALCULATE ( SUM ( Table[Value] ), FILTER ( ALLEXCEPT ( Table, Table[Skill] ), Table[Matric] = "Vol. Handled" ) )
If it does not meet your requirement, please illustrate how to calculate "Weighted average for ASA(Seconds) based on Vol. Handled". And show us your desired result with above sample table.
Best regards,
Yuliana Gu
I have attached the calculation
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |