cancel
Showing results for
Did you mean: Frequent Visitor

Measure Calculate until last week

I'm trying to get a measure right.

Certain grades are given and I want to see how they progress every week. For that I try to write a measure that has the average of the grade number and filters until the last week.

Unfortunately I cannot get a dynamic week date where the measure has the current week minus 1 (so that it shows the average until last week). Hope someone can help out.

test =

calculate(AVERAGE(table[number]),WEEKNUM('Calendar'[Date])-1)
1 ACCEPTED SOLUTION  Solution Sage

Hi @MdB ,

First, create a weeknumber column in your calendar table:

WeekNumber = WEEKNUM('Calendar'[Date],2)

Then create a measure like this:
test =
var Maxdate = WEEKNUM(TODAY(),2)-1
return
CALCULATE(AVERAGE('Table'[Number]),'Calendar'[WeekNumber]<=Maxdate)

If I answered your question, please mark it as a solution to help other members find it more quickly.  Solution Sage

Hi @MdB ,

First, create a weeknumber column in your calendar table:

WeekNumber = WEEKNUM('Calendar'[Date],2)

Then create a measure like this:
test =
var Maxdate = WEEKNUM(TODAY(),2)-1
return
CALCULATE(AVERAGE('Table'[Number]),'Calendar'[WeekNumber]<=Maxdate)

If I answered your question, please mark it as a solution to help other members find it more quickly.   