thank you for these tutorials. I started using Excel Power tools after reading a few of your articles and it's the best thing ever. although I must say, learning dax is harder than I thought.
For the learn and earn activity - which I am loving by the way, its nice to be collecting these tokens my answers are as follows
Related moved from the many side of a table to the one side and returns a vallue and Related table works from the one side to the many
side returning a tableIn my company there are many data sets where you would need to use the related function or related table.
RE: Related and RelatedTable - DAX for Power Pivot, Power BI and SSAS