creating measure to calculate the average of sum of value

[osama_ayoub]

I have a table and I want to create measure to calculate the monthly average of total cost per each day

so

1- I want to sum the total value per each date 

2- I want to get average of the sum per each month (the number of days per each month are not equal ,I mean there are 5 dates in august but in sepryember only 4 ....etc) 

I hope my question is clear enough

Best Regards 

[amitchandak · Accepted solution]

@osama_ayoub , Try a measure like

averagex(Values(Table[Date]), calculate(Sum(Table[Value])) )