Hello Everyone, sorry for the delay in the writeup.
With this entry I didn’t have much time to put things together, or it would have been a bit more detailed. I put this whole report together in about 3 hours on Sunday. This probably wouldn’t have gotten completed if it wasn’t for some great tips from @Greg & @BrianJ ! It is always great to share ideas and thoughts with these challenges with these 2!
For my color choice, I was inspired by the great 1988 movie “Cocktail”. I bet a majority of you are too young to appreciate this movie.
Here is a snapshot of the cover:
I tried to keep the data model as simple as possible, but this probably took longer than any other section of building the report. I would have never thought to do something like @BrianJ did with his model. I’m encouraging him to do a video on this technique, as I think many could benefit from it!
Here is what the Data model looked like:
I had to do a few complex DAX measures with this model, but tried to keep the others fairly simple. I wish I had more time to put into this challenge, but grateful that I was able to pull something together at the last minute.