topic Re: Last 7 days AVARAGE in DAX Commands and Tips

Last 7 days AVARAGE

Lucasr46 — Wed, 12 Apr 2023 14:47:56 GMT

Hello everyone. How it's going?

I need to create an avarage of the requests made of the last 7 days.

Each line of the table is a request.

The collum "Prazo separacao" is my date.

Please, who can help me?

Re: Last 7 days AVARAGE

MohammadLoran25 — Wed, 12 Apr 2023 18:45:47 GMT

Hi Lucasr46 ,

Use this measure:

Measure = VAR _MAXDATE = CALCULATE ( MAX ( RequestTable[Date] ), ALL ( RequestTable ) ) RETURN DIVIDE ( CALCULATE ( SUM ( RequestTable[Request] ), FILTER ( RequestTable, RequestTable[Date] <= _MAXDATE && RequestTable[Date] >= _MAXDATE - 6 ) ), CALCULATE ( COUNTROWS ( VALUES ( RequestTable[Date] ) ), FILTER ( RequestTable, RequestTable[Date] <= _MAXDATE && RequestTable[Date] >= _MAXDATE - 6 ) ) )

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran

Re: Last 7 days AVARAGE

FreemanZ — Wed, 12 Apr 2023 23:06:48 GMT

hi Lucasr46

it depends on the starting point of last 7 days, if you mean Today/Now, try like:

Measure =

DIVIDE(

SUMX(

FILTER(

Data,

Data[Date]>NOW()-7&&Data[Date]<=NOW()

Data[Qty]

)