How to calculate average number of month ?

[admin_xlsior]

Hi,

I'm curios to understand how are we calculate or get a value for Average number of month ?

Lets say 200 Orders, the receive days vary between days and months, but I want to get Average number of month of my receving. Also because days in months is vary, right.

Need some advice.

Thanks

[v-xiaotang]

Hi @admin_xlsior 

Have you tried the dax expression mentioned by amitchandak? Does it work? Also, you can customize the average expression, just use function datediff() to calculate the total days of the period. Then use divide() function to calculate average.

DATEDIFF function (DAX) - DAX | Microsoft Docs

DIVIDE function (DAX) - DAX | Microsoft Docs

Best Regards,

Community Support Team _Tang

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

[amitchandak · Accepted solution]

@admin_xlsior ,

Sum at day level Avg above

calculate(AverageX(Values('Date'[Date]), [Count of order measure] ) )

monthly using TI

calculate(AverageX(Values('Date'[Date]), [Count of order measure]) , datesmtd('Date'[Date])  )

Sum at Month level Avg above

calculate(AverageX(Values('Date'[Month year ]), [Count of order measure] ) )