Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Difference between Dates(Weeks)

Hello I have a couple of fields  Week and Avgerage of Rounded Open Hours, I want to calcualte the difference between weeks difference between 8/29/2022- 8/22/2022. How do I do that? T...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You could create a measure like 

    Week on week diff =
VAR thisWeek =
    SELECTEDVALUE ( 'Table'[Week] )
VAR thisWeekValue =
    SELECTEDVALUE ( 'Table'[Average of Rounded Open Hours] )
VAR lastWeekValue =
    LOOKUPVALUE (
        'Table'[Average of Rounded Open Hours],
        'Table'[Week], thisWeek - 7
    )
RETURN
    thisWeekValue - lastWeekValue
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure how your data model looks like, but I tried to create a sample pbix file like below.

The below sample shows how to find the previous week's data.

I hope the below can provide some ideas on how to create a solution for your dataset.

 

 

 

Prev. week avg open hrs: =
CALCULATE (
    [Avg of open hours:],
    'Calendar'[Start of Week]
        = MAX ( 'Calendar'[Start of Week] ) - 7
)