Forum Discussion
Helper IIIDischarge department
Hi,
I want to make a report witch contains the following information.
Out of a big data file I want to extract the follow up department.
So I have department A and how many have a transfer (discharge) to deparment B & C etc.
| Reference | Start date | End date | Discharge (out of hospital) | Department |
| 1 | 1-11-2022 16:00 | 10-11-2022 10:11 | A | |
| 1 | 10-11-2022 10:11 | B | ||
| 2 | 2-11-2022 15:35 | 3-11-2022 13:34 | 3-11-2022 13:34 | A |
| 3 | 1-11-2022 09:15 | 2-11-2022 10:24 | A | |
| 3 | 2-11-2022 10:24 | 3-11-2022 18:12 | 3-11-2022 18:12 | C |
So you can see that reference 1 transfer from department A to B at 10-11-2022 10:11.
Reference 2 is discharged out of the hospital direct from department A.
Reference 3 transfers to department C and gets discharged out of that department (I don't want to know that discharge, only the report of department A to witch department the patient is transferd or discharged).
The file contains every department in the hospital.
Hope some can make the measure because with my knowledge... 🙂
24 Replies
- tamerj1
Community Champion
Hi bdeleur
Please refer to attached sample file with the proposed solutionCount = SUMX ( VALUES ( 'Table'[Reference] ), VAR CurrentTable = CALCULATETABLE ( 'Table' ) VAR FirstRecord = TOPN ( 1, CurrentTable, 'Table'[Start date], ASC ) VAR LastRecord = TOPN ( 1, CurrentTable, 'Table'[Start date] ) VAR FirstDepartment = MAXX ( FirstRecord, 'Table'[Department] ) VAR LastDepartment = MAXX ( LastRecord, 'Table'[Department] ) RETURN IF ( FirstDepartment <> LastDepartment && MAX ( 'To'[Department] ) = LastDepartment && MAX ( 'FROM'[Department] ) = FirstDepartment, 1 )- bdeleur
Hi,
I applied the code and it seems to work fine. I have to do and check to the outcome to be sure. Just 1 thing is missing: the code doesn't count the patients who have a discharge out of hospital.
How can we do that?
- tamerj1
bdeleur
Please tryCount = SUMX ( VALUES ( 'Table'[Reference] ), VAR CurrentTable = CALCULATETABLE ( 'Table' ) VAR FirstRecord = TOPN ( 1, CurrentTable, 'Table'[Start date], ASC ) VAR LastRecord = TOPN ( 1, CurrentTable, 'Table'[Start date] ) VAR FirstDepartment = MAXX ( FirstRecord, 'Table'[Department] ) VAR LastDepartment = MAXX ( LastRecord, 'Table'[Department] ) VAR DischargeDate = MAXX ( LastRecord, 'Table'[End Date] ) RETURN IF ( AND ( FirstDepartment = LastDepartment, DischargeDate <> BLANK () ) && MAX ( 'To'[Department] ) = LastDepartment && MAX ( 'FROM'[Department] ) = FirstDepartment, 1 ) )
andhiii079845Solution Sage
Hi,
can you please give more information what the measure should count exactly:
Tranfer of patient from A,B,C, to A,B,C? Like a matrix?From / to A B C A 1 4 B 2 .... C 3 .... - bdeleur
Hi,
I really like the idea of the matrix. Didn't think about that. So I would like tot see that.
From there I think it is easy to filter for every department.
Is that possible?
- andhiii079845
Yes, you can have one filter for the starting and one filter for the ending department.
But i need more example data to create the measure and you have to make more clear how you handle or want to see the discharge out of the hospital. Also what is with cases like A -> B -> A -> out of the hospital how you count it? without the station between start and end?
- bdeleur
Hi, andhiii079845
A movement between departments uses the start and end date. When the end date and dismissal date are the same then the patient is discharged form that department.
patient 1 only had a transfer a to B, no discharge out of hospital
patient 2 didn't moved to another department and gets discharged out of hospital
patient 3 moved from department A to B and gets discharged out of B
Is that what you need?
- andhiii079845
Thank you for the explanation. So the discharge out of the hospital is not relevant, right? How you want to handle the case if a person go from A to B to C or A to B to A. ? Should every transfer should be count ?
