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
Wondering here if it'd be better to create a table with year, month, week, day, etc. and then somehow create filters or slicers to display the data. Or if I should put in the date table something like you said, end week column, and then connect the two through those columns. Guess it's the relationship between the two where I don't know much about.