Forum Discussion
Average DAX
Hi, I am getting huge difference between Last X Days Sales(i.e below hundred) and Average Last X Days Sales (aroung 1 million). can any one tell me what is wrong with Average Last X Days Sales me...
This might be as simple as you are using sum instead of sumx.
Yours-
RETURN
CALCULATE (
SUM(sales[salesDetail.qty]),
DATESINPERIOD ( 'Calendar'[Date], LASTDATE( 'Calendar'[Date] ), day, DAY )
)
Change to
RETURN
CALCULATE (
SUMX(sales[salesDetail.qty]),
DATESINPERIOD ( 'Calendar'[Date], LASTDATE( 'Calendar'[Date] ), day, DAY )
)