Forum Discussion
Solved
Get data from Previous week with all values.
Dear All, Before I start, sorry for my English. Here is my Data Source And I want to create a DAX to get SUM of revenue of the prevoius week with all Pack, QouteNum, and Team. Here is my DAX...
Hi nutdiablo
Could you please try the measures below:
Revenue = SUM ( Sheet1[Revenue] )Previous Week Revenue = VAR _prev = SELECTEDVALUE ( DimWeek[WeekNumber] ) - 1 RETURN CALCULATE ( [Revenue], REMOVEFILTERS ( DimWeek[WeekNumber] ), DimWeek[WeekNumber] = _prev )Create formatting measures:
Revenue (0) := COALESCE ( [Revenue], 0 )Prev Week (0) := COALESCE ( [Previous Week Revenue], 0 )Data :
Outcome :
rohit1991
Super User
Super UserHi nutdiablo
Could you please try the measures below:
Revenue = SUM ( Sheet1[Revenue] )Previous Week Revenue =
VAR _prev = SELECTEDVALUE ( DimWeek[WeekNumber] ) - 1
RETURN
CALCULATE ( [Revenue],
REMOVEFILTERS ( DimWeek[WeekNumber] ),
DimWeek[WeekNumber] = _prev
)
Create formatting measures:
Revenue (0) := COALESCE ( [Revenue], 0 )Prev Week (0) := COALESCE ( [Previous Week Revenue], 0 )
Data :
Outcome :
It work! Thank you very much.