Generate a calculated column to capture patient "Readmitted (Y/N)", in a data Model

Hi Guys,
I am actually struggling to create a calculated column "Readmitted (Y/N)" for the list of patients who are admitted to a specific care unit, in a hospital-setting for a specific time period (Say: 01Jan2018 to 31March2018). The Criteria for readmitted (Yes) is: If the Patient is admitted to the care Unit more than once, during the same hospital stay (meaning: Hospital Admit Date remain the same, whilst Care Unit Admit Date are multiple).

For instance: I have 2 tables- one an identifier table with unique lists of PatientID(dIdentifiers) and a fact table (fDATA) with the list of admissions to a unit/department within a hospital. The tables are linked together with the common column "PATIENTID", and the table looks like this:

PATIENTID__________________HospitalAdmitDate____CareUnitAdmitDate___CareUnitDischargeDate____HospitalDischargeDate_______Readmitted (Y/N)
3________________________25-01-18 9:30_______25-01-18 10:02______27-01-18 10:49_________ 05-02-18 11:15
2_________________________20-03-18 18:46______20-03-18 19:01______21-03-18 13:40_________21-03-18 13:40
1_________________________15-02-18 14:34______17-02-18 11:30______18-02-18 18:00_________18-02-18 18:00
5________________________05-01-18 0:43________13-01-18 16:00______17-01-18 13:41________19-03-18 16:15
5________________________05-01-18 0:43________27-01-18 21:43______29-01-18 13:16________19-03-18 16:15
4_________________________23-11-17 21:45_______17-01-18 15:07______19-01-18 15:30_________26-01-18 17:10
8_________________________13-02-18 19:27_______22-02-18 14:15______24-02-18 12:08_________27-02-18 14:00
8_________________________30-01-18 11:55_______24-02-18 10:27______26-02-18 10:43_________06-04-18 9:04
7_______________________23-01-18 12:58_______23-01-18 17:00______25-01-18 14:02_________27-01-18 17:45
10________________________22-01-18 6:41________23-01-18 12:15______24-01-18 14:30_________31-01-18 12:40
10________________________22-01-18 6:41________22-01-18 12:50______23-01-18 10:00_________23-01-18 10:20
11_______________________08-02-18 13:44_______09-02-18 14:26______12-02-18 15:40_________16-02-18 20:30
9_______________________27-02-18 11:14_______27-02-18 18:07______01-03-18 7:04___________02-03-18 15:28

Now, I want to create a separate calculated column "Readmitted(Y/N)" based on the criteria that if a case of admission (represented by each row) occurs more than once, during the same hospital stay (rows having the same hospital admit date, but a varying CareUnitAdmitDate, which is after the HospitalAdmitDate). In above table, the latter rows of Patient ID 5 (Anthony) and Patient ID 10 (Christi) are 'readmit cases' as they reappear under the same patient within the same "HospitalAdmitDate". I tried creating few 'measures', and a calculated column using the 'CALCULATE, FILTER Functions', but still couldn't get the value (Y=For Readmit case/row,N=For non-readmit case/row) for the "Readmitted" calculated column.
Could anyone have a solution to this please?

Not saying I'll answer this but that table's difficult to read.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Guys,
I am actually struggling to create a calculated column "Readmitted (Y/N)" for the list of patients who are admitted to a specific care unit, in a hospital-setting for a specific time period (Say: 01Jan2018 to 31March2018). The Criteria for readmitted (Yes) is: If the Patient is admitted to the care Unit more than once, during the same hospital stay (meaning: Hospital Admit Date remain the same, whilst Care Unit Admit Date are multiple).

For instance: I have 2 tables- one an identifier table with unique lists of PatientID(dIdentifiers) and a fact table (fDATA) with the list of admissions to a unit/department within a hospital. The tables are to be linked together with the common column "PATIENTID" (Primary key on table "dIdentifers"). The SAMPLE table (with de-identified data) is attached (.xls file):

Now, I want to create a separate calculated column "Readmitted(Y/N)" based on the criteria that if an episode of admission (represented by each row) occurs more than once, during the same hospital stay (rows having the same hospital admit date, but a varying CareUnitAdmitDate after the HospitalAdmitDate) then, its considered 'readmitted'. I tried creating few 'measures', and a calculated column using the 'CALCULATE, FILTER Functions', but still couldn't get the value (Y=For Readmit case/row,N=For non-readmit case/row) for the "Readmitted" calculated column.

Would like to request for a solution please.

Thank you

Hi kam77. Welcome to the forum.

Try

Formula:

Please Login or Register  to view this content.

Please see next post.

I needed to read the instructions more carefully.

There are two thought errors in my previous formula. It needs an extra test.

Formula:

Please Login or Register  to view this content.