cancel
Showing results for
Did you mean:
Frequent Visitor

## Average value for last 7 day in other table

Hi,

I need count in column Table2[Last7d] average Table[TotalProduct] value of the last 7 days ofr each employee.

I was looking solution on similar topics, but i didn't find it.

How does it look in DAX?

I tried: Last7d = CALCULATE(

AVERAGE(

Table1[TotalProduct]),

DATESINPERIOD(Table1[Date],

LASTDATE(Table1[Date]),-7,DAY))

but i have only results 1 and 0.

Where did I make mistake ?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Average value for last 7 day in other table

@arveseba wrote:

Hi,

I need count in column Table2[Last7d] average Table[TotalProduct] value of the last 7 days ofr each employee.

I was looking solution on similar topics, but i didn't find it.

How does it look in DAX?

I tried: Last7d = CALCULATE(

AVERAGE(

Table1[TotalProduct]),

DATESINPERIOD(Table1[Date],

LASTDATE(Table1[Date]),-7,DAY))

but i have only results 1 and 0.

Where did I make mistake ?

@arveseba

For those functions DATEINPERIOD, LASTDATE, PREVIOUSMONTH etc, please use a consecutive calendar table. Then change the measure a little bit. The attached demo is for your reference.

```Last7d =
CALCULATE (
AVERAGE ( Table1[TotalProduct] ),
DATESINPERIOD ( DateTable[Date], LASTDATE ( DateTable[Date] ), -7, DAY )
)```

Moderator

## Re: Average value for last 7 day in other table

@arveseba wrote:

Hi,

I need count in column Table2[Last7d] average Table[TotalProduct] value of the last 7 days ofr each employee.

I was looking solution on similar topics, but i didn't find it.

How does it look in DAX?

I tried: Last7d = CALCULATE(

AVERAGE(

Table1[TotalProduct]),

DATESINPERIOD(Table1[Date],

LASTDATE(Table1[Date]),-7,DAY))

but i have only results 1 and 0.

Where did I make mistake ?

@arveseba

For those functions DATEINPERIOD, LASTDATE, PREVIOUSMONTH etc, please use a consecutive calendar table. Then change the measure a little bit. The attached demo is for your reference.

```Last7d =
CALCULATE (
AVERAGE ( Table1[TotalProduct] ),
DATESINPERIOD ( DateTable[Date], LASTDATE ( DateTable[Date] ), -7, DAY )
)```