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
johnt75's avatar
johnt75
Super User
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