Forum Discussion
Solved
Creating a data model to track appointments over time
Hey all, I am looking to reduce the manual reporting effort in Excel using PowerBI instead. I've got a spreadsheet that looks similar to the sample one below with some store information along wit...
Hi:
Here is one possible way. Please see link. I guessed about appointment status, but this was more for model design.
I'll attach link for the pbix and excel in case you want to see what data I started with. Model diagram below. I hope this helps gets you going!
https://drive.google.com/file/d/15cPS2lK9ZeEcUhPeq21mDZNTYQYKf0RI/view?usp=sharing
Excel
Hi jroob,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng