You’re offline. This is a read only version of the page.
4
I have a table with 22,000 rows of data in a category
I have a list "Category" , "reported Date" that's it. 22,000 in my list
there are 83 different category's in my list.
try to get Average per year and month. i don't know what i am doing wrong.
thank you
| Category | Reported date |
| Clinical equipment / consumables | 26/05/2022 |
| Documentation / health records | 20/12/2022 |
| Information Governance | 21/02/2022 |
| Communication | 24/06/2022 |
| Documentation / health records | 16/09/2022 |
| Verbal Abuse | 29/12/2022 |
| Actual Physical Assault | 12/09/2022 |
| Systems of work | 26/09/2022 |
| Breach of policy / protocol / procedure | 05/10/2022 |
| Patient journey | 07/03/2022 |
| Discharge issues/concerns | 05/10/2022 |
| Discharge issues/concerns | 14/09/2022 |
| Breach of policy / protocol / procedure | 14/09/2022 |
| Breach of policy / protocol / procedure | 07/12/2022 |
| Speech and Language Therapy | 04/10/2022 |
| Flood | 24/10/2022 |
| Flood | 24/10/2022 |
| Treatment / procedure | 06/11/2022 |
| Moisture Associated Skin Damage | 04/09/2022 |
| Breach of policy / protocol / procedure | 18/11/2022 |
this forum is not for Power BI. It is for Power Query. Power BI has its own community at https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi
#1
mmbr1606
7
Super User 2025 Season 1
#2
SD-13050734-0
4
#3
lbendlin
2
Super User 2025 Season 1
Share
Report
All responses (
Answers (
