Forum Discussion

cham's avatar
cham
Post Patron
7 years ago

Difference between previous week data

Hi ,   I used following measures to calculate difference between previous week data,   table = Calendar (dateStart;dateEnd)   Measure = calculate(sum('Sheet1'[Total]), filter('Table', 'Table'...
General Comment
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

cham  - You can use a variable in your "previous week" measure:

Measure 2 = 
var prev_week_num = WEEKNUM(max('Sheet1'[Date]),1)-1
calculate(
    sum('Sheet1'[Total]),
    'Table'[Column] = prev_week_num 
)

Hope this helps,

Nathan

parry2k's avatar
parry2k
Super User
7 years ago

cham I know Anonymous solution will work but one should always add Datetable in your model and work thru that for all time intelligence related reporting.

 

There are many way to add date table in your table either using DAX or M