How to calculate average amount of orders per day, weeks, months, etc.

[LogixAdex]

I need help with getting the average qty of invoices PSIXXXX (No - field) based on the day posted (Posting_Date)

[amitchandak · Accepted solution]

@LogixAdex , Create date table a having day , week and month

The create measure like 

divide(sum(table[Qty]), distinctcount(Date[Year Week]) )

or a measure like

Averagex( Values(Date[Week Year]), Calculate( Sum(Table[QTY])) )

[v-jayw-msft · Accepted solution]

Hi @LogixAdex ,

You could create a measure like below:

Measure = CALCULATE(AVERAGE('Table'[qty]),FILTER(ALLEXCEPT('Table','Table'[order]),WEEKNUM('Table'[date])=WEEKNUM(SELECTEDVALUE('Table'[date]))))

For per day and per month, just change the corresponding condition in the formula.

Best Regards,

Jay

[amitchandak · Accepted solution]

@LogixAdex , Create date table a having day , week and month

The create measure like 

divide(sum(table[Qty]), distinctcount(Date[Year Week]) )

or a measure like

Averagex( Values(Date[Week Year]), Calculate( Sum(Table[QTY])) )