Forum Discussion

DJSwezey's avatar
DJSwezey
Icon for Helper I rankHelper I
3 years ago

Week over week compiling sales.

I have a table 'GoalsByWeek' that contains [Sales Goal Amount], [Actual Sales Amount] and [WeekOf]. I have created another table called 'WeekOrder' that contains [WeekOf] and [Week Num] from 'GoalsB...
"Need Help"
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

DJSwezey please try this

 

 

WOW Sales Amount = CALCULATE(sum('GoalsByWeek'[Actual Sales Amount]),DATESBETWEEN(All('GoalByWeek'[WeekOf]),max('GoalsByWeek'[WeekOf])-1000,max('GoalsByWeek'[WeekOf])))

 


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DJSwezey's avatar
DJSwezey
Icon for Helper I rankHelper I
3 years ago

I unfortunately get this error when I use that measure: