Forum Discussion
Distinct Service Date Count For Each Month
Hi Nate, apologizes but I just recently started to use PowerBi more regularly. My last organization was Tableau so had very limited usage of Microsofts tool. I am super confused. When I removed the date hierarchy alot of my graphs blew up becuase some of them are using the hierarchy fro month by month trending. I still need those so I would have to somehow take the service date take the month out of it and tag it again? Is there a way to duplicate the hierarchy and just get the service date in dd/mm/yyyy format so it knows how to use it accurately? When playing more with this, I picked a specific person and selected January and added a patient name count...when I do that it accurately captures the service dates.
See below:
But when I take the patient names out of it it gives me every date so I think its
Is there a way to do a service date count if there are patients on that service date? Maybe we can do it that way?
I ideally I want to get statistics to give me out of all of my doctors what is the average patients seen and the way to do that is count patients then divide by the service dates. I want to do this on an enterprise level and then on a doctor level. Eventually I want to compare if they are above or below the average..
Can you help?