DAX LAST7DAYS AVG

[Anonymous]

Hi,

Why do huge difference is coming between Last7d(22425822 etc) and Last7d avg(13.09 etc) values which has shown in below table.could any one please modify my dax.

Last7d =

CALCULATE (

SUMX(sales,sales[salesdetail.qty]),

DATESINPERIOD ( 'Calendar'[Date],LASTDATE ('Calendar'[Date]),-7,DAY )

)

Last7d avg =

CALCULATE (

AVERAGE (sales[salesdetail.qty]),

DATESINPERIOD ( 'Calendar'[Date],LASTDATE('Calendar'[Date]),-7,DAY )

)

Last7d        Last7d avg  Date
22425822     13.09     1-Aug-19
30914263     11.89     2-Aug-19
8642104       11.13     3-Aug-19
7504866       11.25    4-Aug-19
9374137       9.91      5-Aug-19
7521041       9.06       6-Aug-19
8354975       8.54       7-Aug-19
8453644       8.88       8-Aug-19
8137744       9.19       9-Aug-19

[amitchandak]

Have you check manually which one is correct. Check the Sum and Avg using this

Sales 10 Days = ( 
VAR _Cuur_start = Max('Compare Date'[Compare Date]) -7
VAR _Curr_END = Max('Compare Date'[Compare Date])
return 
calculate((sum(Sales[Sales Amount]),Sales[Sales Date] >= _Cuur_start && Sales[Sales Date] <=  _Curr_END )
)

[JVidal]

Hey, 

My guess is that you are using SUMX instead of SUM, so you are basically summing the entire sales table and then calculate what that is for the 7d.

Try changing SUMX by SUM