Difference between Dates(Weeks)

[Anonymous]

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?

Thanks!

[Jihwan_Kim]

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
)

[Tahreem24]

@Anonymous You want different between weeks as a Day OR difference beween weeks as Opened Hours? PLease also share the expected result which you want.

[johnt75 · Accepted solution]

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