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
Whitewater100
Solution Sage
Solution SageHi:
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