Forum Discussion
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?
Thanks!
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
3 Replies
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 - lastWeekValueHi,
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 )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.
