Number of Patient Visits in same Day

[Mamoun_issa]

Hello,

I Have a schedule of patients visits that looks similar to this:

Visit ID	Patient Name	Patient Number (MRN)	Procedures Made	Visit Date	Amount
1001	Joesph	MR50003	A	1 January 2019	100
1001	Joesph	MR50003	B	1 January 2019	50
1001	Joesph	MR50003	C	1 January 2019	20
1020	Joesph	MR50003	X	1 January 2019	500
1020	Joesph	MR50003	Y	1 January 2019	60
1020	Joesph	MR50003	Z	1 January 2019	250

I want to add a column to classify wethed this patient have a visit in the same day 

[dax]

Hi Manoun_issa,

You could refer to @Thim 's suggestions, if this is not what you want, please inform me more detailed information (such as your sample data and youir expected output). Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thim · Accepted solution]

Hopefully someone who knows how to add this to your current matrix answers you.

I could not find a perfect answer, but i do have a different solution.

first add this meassure

Revisit = IF(DISTINCTCOUNT('Table'[Visit ID])=1;"No";"Yes")

Then make a new matrix with the following columns.

Patient Name,

Patient Number (MRN),

Visit Date,

and your new meassure. (Revisit)

Your final result should look like this. (I added a few extra dates in your example data, to test a bit)

Hope this will help. 🙂