<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Relating Related Tables in Power BI to Baseball (I Miss Sports)

Relating Related Tables in Power BI to Baseball (I Miss Sports)

Baseball Consolidating Tables Image for Matts blogI miss sports. In particular, I miss baseball.

Between learning more Power BI functions and the ins-and-outs of DAX, I've turned to Netflix to fill the deep caverns left in my soul since baseball season has been postponed. And as a result, I've thought about tigers and big cats more than I ever have in my life.

I know ALL about Carol Baskins and am fully on board for a spin-off centering on locating her lost husband. I've googled "is it really legal to own a tiger in a residential area?" Without baseball in April, I am barely hanging in there (kinda like Joe Exotic's eyebrow ring).

So, I am filling the sports-sized hole by using baseball stats in Power BI to demonstrate pulling data from multiple tables and consolidating it into one table. Some of the data we want to consolidate also has to have some aggregations (which is fancy for "calculations") performed on it. 

In this demo I will attempt to break down what is really going on behind the scenes of Power BI.  You all know I like to bring in my teacher lingo whenever possible and that's what I'll do as I use baseball to demonstrate how to easily bring data from one table to another using the RELATED FUNCTION and how to bring back MULTIPLE values AND do a calculation with them using the function RELATEDTABLE. 


Thank you for following my journey from Algebra Teacher to Power BI trainer and let me know how I can help you!

To follow my blog, The Algebra Teacher Powers to B.I. click here

If you want or need to increase your Power BI skills, Pragmatic Works On-Demand Learning platform is the perfect place to do it. Our 17 Power BI courses will turn you into a Power BI expert by providing in-depth instruction on all of the capabilities that Power BI provides. Click the link below to get started with a FREE trial! 


Sign-up now and get instant access

Leave a comment

Free Trial

On-demand learning

Most Recent

private training

Hackathons, enterprise training, virtual monitoring