Completely off topic but, I am having trouble understanding how to map out table relationships. I am currently working on Maven Ski Challenge and having trouble thinking about how to match the snow with the seasons given that one is a date and the other is just text.
For the seasons, I created a matrix of the months it covered. Then I unpivoted. Therefore you would have seasons in one column, and corresponding month in the next column. This would give you a rather long list. Then I joined the snow data using a combination of the coordinates and the month in order to bring in the snow fall. That might sound a little confusing.
@@dganalysis I think I understand. It sounds like you created a matrix table for the snow file, then in power pivot/ transform data you unpivoted the table
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
I really like this direction of video production you're taking, great stuff!
Thank you Injae, appreciate it - but this book might be a little too niche 😅
Thank you Gernard for the recommendation.
Completely off topic but, I am having trouble understanding how to map out table relationships. I am currently working on Maven Ski Challenge and having trouble thinking about how to match the snow with the seasons given that one is a date and the other is just text.
For the seasons, I created a matrix of the months it covered.
Then I unpivoted. Therefore you would have seasons in one column, and corresponding month in the next column. This would give you a rather long list.
Then I joined the snow data using a combination of the coordinates and the month in order to bring in the snow fall.
That might sound a little confusing.
@@dganalysis I think I understand. It sounds like you created a matrix table for the snow file, then in power pivot/ transform data you unpivoted the table
@@Kdcamp08 yes, used unpivot in power query.