Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
PompeuPD
Frequent Visitor

Calculate average date difference between births

Hi,

 

In this query I have two separate tables. One with baby cows that have been born, and the second with the mothers.

 

In the first one I have the following columns

Baby cow ID

Mothers ID code 

Date of birth

 

In the second I have the following column

Mothers ID code

 

The problem is that the same mother can give birth multiple times. So in the first table I sometimes have the same Mothers ID code with different birth dates

 

I want to be able to calculate the average time difference, that a given cow gives birth so that i end up with a table with these columns:

Mothers ID code

Month Average between Births (For example: 12.3 months)

 

I merged the two tables but i ended up with duplicates Mothers ID code (as expected), and i dont know where to go from there.

Table after merge:

Mothers ID code         Date of birth

1001                            10/2/2015

1001                            11/2/2016

1001                              7/3/2017

1002                            10/4/2017

1003                            7/10/2016

1003                              8/9/2017

...

 

The result I want:

Mothers ID code      Month Average between births

 

 

Hope that someone can help me 

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.