Forum Discussion
MarinaSaadalla
Mar 07, 2021Copper Contributor
Tracking for patients
I'm working on a project. I need to track the patient movements within 14 days if he/she went to same service within 14 days so it will appear with different color as the sheet contains around 16k me...
Yea_So
May 11, 2021Bronze Contributor
MarinaSaadalla Here's a tool that might be helpful. You enter the Card Number and it will list all transactions related to the card:
Hope that helps you in your project.
Cheers
- MarinaSaadallaMay 16, 2021Copper ContributorCan you help me to understand what you did i'm trying to do it again but i fail
- Yea_SoMay 16, 2021Bronze ContributorI'll make instruction for you its a power query 2 tables, one main list table and the other is the variable table, the variable table is where you input your search criteria. I will make instruction so you can follow
- MarinaSaadallaMay 16, 2021Copper Contributoryes, instructions will be more helpful.
your effort is appreciated.