Forum Discussion
Solved
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...
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
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
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,PragatiI dont have a table name, since i used a measure to get the difference.