Forum Discussion
MuthalibAbdul
Helper II
Helper IIWeekly average of a string column based on category instances
So I have a table with patient name, which physician has seen and when. I need to be able to count the number of patients seen per physician (which is achievable by simply using a table). However, no...
MuthalibAbdulHelper II
Helper II
Ashish_Mathur
Super User
Super UserHi,
In the Calendar table, create a week number column. To your Matrix visual, drag Year and week number to the column labels and Physician to the Row labels. Write this measure
Measure = counta(Data[Physician])
Hope this helps.