Forum Discussion
Creating a measure to show testing completed last week
Hi, I am trying to create a measure to show the number of tests that were changed to testing complete last week. I have created a week column that has assigned all change dates a week number e.g...
Anonymous , Try using
LastWeekTestsCompleted =
VAR CurrentWeek = MAX('Project Test'[Week])
VAR LastWeek = CurrentWeek - 1
RETURN
CALCULATE(
[Project Test Completed],
'Project Test'[Week] = LastWeek
)
That worked a treat - thank you so much!