Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |