cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kondoajames
New Member

undefined

I have start date from one table and end date from another table,i have used dax to find the difference, how do l find average of the difference?

 

ID             Table  x(Start date)         Table Y(End date)       No of Days taken

2                   2-2-2020                       2-24-2020                       20

6                   2-3-2020                       2-20-2020                        17

 

How do i find the average number of days using dax having start date and end date are from two different tables

1 ACCEPTED SOLUTION

Hi @kondoajames ,

 

You can simply create a measure as follows:

AverageDateDiff =
AVERAGE(tableanme[No of days Taken])
 
Replace your tablename and column name in above dax expression.
 
Thanks,
Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

6 REPLIES 6
Pragati11
Super User
Super User

HI @kondoajames ,

 

Is there any relationship between these 2 tables?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Yes they joined by the ID

Hi @kondoajames ,

 

Have you already calculated the difference in dates?

You require a single AVERAGE value for this difference right?

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Yes, just a single average value.

Hi @kondoajames ,

 

You can simply create a measure as follows:

AverageDateDiff =
AVERAGE(tableanme[No of days Taken])
 
Replace your tablename and column name in above dax expression.
 
Thanks,
Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

I dont have a table name, since i used a measure to get the difference.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.