Forum Discussion
Patient Tracker and Package Tracker
Hi sanjurk_1506 ,
Do you want to get package price for each recored in Patient Attendance Tracker? If so , you could add a caculate column for Patient Attendance Tracker. I'v made a test for your reference:
Package Price = CALCULATE( MAX('atient Price Tracker'[Package Price]), FILTER( 'atient Price Tracker', 'atient Price Tracker'[Patient ID] = 'Patient Attendance Tracker'[Patient ID] && 'atient Price Tracker'[Package] = 'Patient Attendance Tracker'[Department] && 'atient Price Tracker'[Package To] >= 'Patient Attendance Tracker'[Date] && ('atient Price Tracker'[Package From] <= 'Patient Attendance Tracker'[Date] || IsBlank('atient Price Tracker'[Package From])) ) )Best Regards,
Bof
Hi sanjurk_1506 ,
Do you want to get package price for each recored in Patient Attendance Tracker? If so , you could add a caculate column for Patient Attendance Tracker. I'v made a test for your reference:
Package Price = CALCULATE(
MAX('atient Price Tracker'[Package Price]),
FILTER(
'atient Price Tracker',
'atient Price Tracker'[Patient ID] = 'Patient Attendance Tracker'[Patient ID] &&
'atient Price Tracker'[Package] = 'Patient Attendance Tracker'[Department] &&
'atient Price Tracker'[Package To] >= 'Patient Attendance Tracker'[Date] &&
('atient Price Tracker'[Package From] <= 'Patient Attendance Tracker'[Date] || IsBlank('atient Price Tracker'[Package From]))
)
)
Best Regards,
Bof
Anonymous
This is working out, but is there a change that could be done that, instead of 0 I have put 200 on the second line below.
What I meant by the blank is that the package starts from Wednesday, 2 October 2024, but the end date is nto know, so until then the package price will 200.
The blanks mean that the end date of the package is not known - it will be either when the client stops coming.
| atient Name | Therapist | Patient ID | Package From | Package To | Package Price | Package |
| Shyam Hani | Sanju | 153 | Wednesday, 2 October 2024 | Wednesday, 4 September 2024 | 100 | Speech Therapy |
| Shyam Hani | Ryaan | 153 | Wednesday, 2 October 2024 | 200 | Occupational Therapy |