Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I have two multiple tables on a cricket dashboard and want to work out the players age at the start of a match.
The first table is called "Bat" and this is what the dashboard is made up off. It has a column called start_date
The other table is called "PP" and that has the player profiles detials and importnatly a date called "Born". These are linked on the data table by a player ID.
I want to add to my dashboard using the daa from "Bat" an age calucalation essentially being - Born - Start Date and leaving just the age.
I've looked through heaps of forums and YT videos and cant quite work it out.
Really hoping someone can help.
Thanks
Rob
Solved! Go to Solution.
Oh! Apologies for that
Average Age =
AVERAGEX (
Bat,
DATEDIFF ( MAXX ( RELATEDTABLE ( PP ), PP[Born] ), Bat[Start_Date], YEAR )
)
Thanks mate
The error message based on that is below
Sounds like the relationship isn't working?
@Chockers1
Please try
Average Age =
AVERAGEX (
Bat,
INT ( Bat[Start_Date] - MAXX ( RELATEDTABLE ( PP ), PP[Born] ) )
)
Thanks mate, this is what appears - is it possible to make that into how old a player is in just years?
Average Age =
AVERAGEX (
Bat,
DATEDIFF ( Bat[Start_Date], MAXX ( RELATEDTABLE ( PP ), PP[Born] ), YEAR )
)
Awesome mate, that has got it working!
The only thing left it shows as a minus age
Any ideas?
Oh! Apologies for that
Average Age =
AVERAGEX (
Bat,
DATEDIFF ( MAXX ( RELATEDTABLE ( PP ), PP[Born] ), Bat[Start_Date], YEAR )
)
thank you so much works beautfully!!!
Thank you, thats the first time its got a calculation out 🙂
That gives me the average age, no quite what I was after.
I guess ideally i just want it to show the years difference between the start Date and the Born date
Hi @Chockers1
please try
Average Age =
AVERAGEX ( Bat, INT ( Bat[Start_Date] - RELATED ( PP[Born] ) ) )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |