Forum Discussion
Counting the number of Diagnosis codes by context ,Specialty and provider-HelpwithPowerQuery/formula
Hi Team,
Hope you are doing well!... I am trying to count the number of diagnosis codes by context ,Specialty and provider..Can you please help me here..Attached the Input and the output required sheets....
Appreciate your help!
Thanks,
Arun
Arun Chandramouli Please see the attached file containing a PQ solution in the Output sheet. I have also noticed some discrepancies, probably caused by the fact that you created the example output manually.
The query is fairly standard, except for one little trick that allows you to split the "Diagnosis code" column based on the maximum number of elements in any given field. I picked it up from a video by Wyn Hopkins not too long ago.
9 Replies
Arun Chandramouli Please see the attached file containing a PQ solution in the Output sheet. I have also noticed some discrepancies, probably caused by the fact that you created the example output manually.
The query is fairly standard, except for one little trick that allows you to split the "Diagnosis code" column based on the maximum number of elements in any given field. I picked it up from a video by Wyn Hopkins not too long ago.
Thanks for the reference Riny_van_Eekelen
There's actually a simpler way using Split Text to Rows option under AdvancedWyn Hopkins Will keep that in mind for next time 🙂
- Riny_van_Eekelen : Really appreciate your response!..Thank you very much for your help...
