Forum Discussion
Finding out AVG
Hi Experts
I am currently facing while calculating Axg in a table. below is my example. I want to calculate avg. how to do in PBI
Avg = Information Acceptance to Completion (Days) which is (58+69) / # of rows which is 2 =63.5
| P | uni Number | Stream | Information Date | Date Accepted | Information Completed | Information Target | Information Acceptance to Completion (Days) | Target | patient accepted on waiting list | Admission Date | Day on Waiting List | Waiting List Target Days | Target | Total (Days) | AVG |
| 1 | 5000977 | Kite Sam | 03-03-2022 00:00 | 08-03-2022 00:00 | 05-05-2022 00:00 | 21 Days | 58 | 0 | 08-04-2022 00:00 | 05-05-2022 00:00 | 27 | 21 | 0 | 63 | 63.5 |
| 1 | 5001011 | Tam Kity | 16-03-2022 00:00 | 17-03-2022 00:00 | 25-05-2022 00:00 | 21 Days | 69 | 0 | 11-04-2022 00:00 | 25-05-2022 00:00 | 44 | 21 | 0 | 70 | 63.5 |
1 Reply
Read about REMOVEFILTERS and ALLEXCEPT.
