Calculated Measure - Average Days

[M_SBS_6]

Hi, 

I have created the following measure which gives me the number of days between 2 dates.

Days_to_comp =

Datediff(

Selectedvalue('apps'[appdate]),

Selectedvalue('comp'[compdate]),

Day)

That seems to work as I'd expect. However, I now want to create another measure that calculates the average, I have tried this, but doesn't work

Average_days_to_comp =

Average (days_to_comp)

Any idea how to resolve, please? Is my original measure incorrect and the reason it won't work?

[v-henryk-mstf · Accepted solution]

Hi @M_SBS_6 ,

According to your description, for the AVERAGE function, its argument is passed a specific column name, while this formula returns a scalar result. So this is the cause of the error.

1 =
DATEDIFF (
    SELECTEDVALUE ( 'apps'[appdate] ),
    SELECTEDVALUE ( 'comp'[compdate] ),
    DAY
)

For more details about how to use average function. You can refer to below blog:

Power BI Average | Examples to Measure Average in Power BI (wallstreetmojo.com)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@M_SBS_6 , A new measure , You need a common table for level of details/ group by

AverageX(values(Dim[Column1]), calculate(

Datediff(

Selectedvalue('apps'[appdate]),

Selectedvalue('comp'[compdate]),

Day) ) )